How to add a total row to a column in a simple question/table?
My table requires totals at the bottom of several columns of figures.
How to add a total row to a column in a simple question/table?
My table requires totals at the bottom of several columns of figures.
If they’re simple sums, the easiest way is to use a Pivot visualization, which will calculate the totals as part of the display.
With a SQL question you’d use UNION ALL to combine 2 queries, one to output the rows and another to compute the totals.
Thanx for that, seems odd that it is not a standard feature in table view.