Reference Grand Total to another colum pivot table

[#1]

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

[sunny_talwar · Accepted solution]

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

[#3]

Thank you man, it works perfect

[sunny_talwar]

No problem

I am glad I was able to help.

Best,

Sunny