Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have simple pivot table with dimensions index and item name, and the measure is quantity in kg.
I need to show in table grand total for the measure, I used the formula:
sum(aggr(Sum([[quantity in kg]]])*-1,index)). And it still does not show the total. Could you please assist on this issue?
Thanks in advance
HI ,
I meant one set of square braces is enough, as your posted expression had multiple square braces , anyways please use :
sum(aggr(Sum([quantity in kg])*-1,index))
And in the right panel select the first dimension. Turn on "Show Totals".
sum(
aggr(
Sum([quantity in kg])*-1
,index)
)
why have you used so many square braces here:Sum([[quantity in kg]]])
use the same exp like sum(aggr(Sum([quantity in kg])*-1,index))
If I remove square braces, it shows the fomula is incorrect. The name of column is [quantity in kg]
I have changed it to sum(aggr(Sum("[quantity in kg]")*-1,index)) and it still does now show the grand total at the end of pivot table. I also used your formula and it does not show grand total at the end of pivot table.
HI ,
I meant one set of square braces is enough, as your posted expression had multiple square braces , anyways please use :
sum(aggr(Sum([quantity in kg])*-1,index))
And in the right panel select the first dimension. Turn on "Show Totals".