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

[Anonymous]

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.

[michael_anthony · Accepted solution]

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

[Anonymous]

Very nice solution.   Thank you Michael.