Gran Total Table

[AndreaSangalli]

Hello,

I have to use a specific table for make totals about my records.

The table it self(unfortunately)is not AppSheet convertible(reusable)

The table is basically the union between 4 sub tables.

Each table has column for the day week and row for Employees.

I saw that there’s the possibility to create a few action to make possible the Gran a total in the last row but in my case doesn’t work.

My solution was to display (ONLY READ) the table and making the the changing through goggle sheet with formulas and query’s, but I think could be a better way to achieve this task.

Someone had my same problem?

Thank in advance

[SkrOYC]

Sometimes what you need is not a "Grand totals table" but instead just one row in a User table where you have virtual columns that calculate totals and then display that as a detail view inside the app

[AndreaSangalli]

Thank for the feedback.

this is very interesting how I can achieve that?

[SkrOYC]

The way I already explained, User table with virtual columns

[jkevz]

Use ref as your key in identifying and getting the total amount.