Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello There!
¿Is it possible in pivot table to reference Grand Total of a cell to another Grand Total cell in the same pivot table?
If someone have the answer, I'll apreciate any help.
My best regards
You can look at the concept of Dimensionality() where you can specify one expression for the rows and another expression for the grand total. Something like this may be:
If(Dimensionality() = 0, YourGrandTotalExpression, YourOtherExpression)
HTH
Best,
Sunny
You can look at the concept of Dimensionality() where you can specify one expression for the rows and another expression for the grand total. Something like this may be:
If(Dimensionality() = 0, YourGrandTotalExpression, YourOtherExpression)
HTH
Best,
Sunny
Thank you man, it works perfect
No problem
I am glad I was able to help.
Best,
Sunny