Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
the dimensionality function on the total line = 0. modify your target function to calculate where dimensionality <= 1.
the dimensionality function on the total line = 0. modify your target function to calculate where dimensionality <= 1.
Very nice solution. Thank you Michael.