Change the total formula in pivot table

[Ashkan]

Hello everyone

This is my data:

And this is my pivot table:

I want to show the TOTAL of B column instead of TOTAL of A.

Please tell me the formula if it's possible.

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

Try the Dimensionality function to calculate different expressions at different levels:

If(Dimensionality()>0, sum(Plan), sum(aggr( ...etc )) )