topic Re: Grand Total missing in pivot table when dimentionality() used. in QlikView

Grand Total missing in pivot table when dimentionality() used.

Anonymous — Thu, 12 Sep 2013 02:33:33 GMT

Hi,

I have a pivot table with 2 dimensions. at the highest dimension (SRG) I have activity and target data. but at the second dimension (DRG) I only have activity data and want to zero out the target data. I use the dimensionality() function to determine if the second dimension is visible. When this is TRUE I return a 0 instead of the SUM().

This works well except when I collapse the DRG dimension I no longer get a grand total at the bottom of the pivot.

Is there a way to have my dimensionality function but also have a grand total at the bottom?

see attachment for example of my issue.

Regards,

John.

Re: Grand Total missing in pivot table when dimentionality() used.

michael_anthony — Thu, 12 Sep 2013 05:15:59 GMT

the dimensionality function on the total line = 0. modify your target function to calculate where dimensionality <= 1.

Re: Grand Total missing in pivot table when dimentionality() used.

Anonymous — Thu, 12 Sep 2013 05:55:54 GMT

Very nice solution. Thank you Michael.