topic Re: Reference Grand Total to another colum pivot table in QlikView

Reference Grand Total to another colum pivot table

Tue, 04 Aug 2015 21:49:41 GMT

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

Re: Reference Grand Total to another colum pivot table

sunny_talwar — Tue, 04 Aug 2015 23:05:13 GMT

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

Re: Reference Grand Total to another colum pivot table

Tue, 04 Aug 2015 23:50:02 GMT

Thank you man, it works perfect

Re: Reference Grand Total to another colum pivot table

sunny_talwar — Wed, 05 Aug 2015 01:43:35 GMT

No problem

I am glad I was able to help.

Best,

Sunny