Hi,
I would like to know the best way to display column totals? Is it the same way I do in Excel where I use the top row to calculate a total of all the items below it? Is there a sleeker way to do this?
Also, how can I see totals when displaying data that is grouped?
The best way to display column totals is to use excel formulas in the Header region above the Table Header row.
For eg, in the case of SUBTOTAL ,
1-11 functions will include rows filtered out in the View
101-111 functions will ignore rows filtered out in the View
In a Grouped View, we provide the option to display group totals out of the box.
Column level Totals based on formulas work as usual when the View is grouped as well.
