Grand total in pivot table

[Edyta]

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

[sasiparupudi1]

sum(

aggr(

Sum([quantity in kg])*-1

,index)

)

[anushree1]

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))

[Edyta]

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.

[anushree1 · Accepted solution]

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".