Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

1 Solution

Accepted Solutions
michael_anthony
Creator II
Creator II

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

View solution in original post

2 Replies
michael_anthony
Creator II
Creator II

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

Anonymous
Not applicable
Author

Very nice solution.   Thank you Michael.