Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try the Dimensionality function to calculate different expressions at different levels:
If(Dimensionality()>0, sum(Plan), sum(aggr( ...etc )) )
Try the Dimensionality function to calculate different expressions at different levels:
If(Dimensionality()>0, sum(Plan), sum(aggr( ...etc )) )