Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with 3 dimensions and several expressions. However I only want to show partial sums for a single expression (Amount). The Total row spans across all columns and attempts to sum them all, even the text columns. I would like to turn off the sums for the text columns. Is this possible?
You could probably handle this using Dimensionality(). Dimensionality() returns the "level" of the cell in a pivot.
Dimensionality() = 0 would be your grand total, the partial sum on the first dimension. Each subsequent level would be higher.
For your text expressions, change them to:
if(Dimensionality()>0, Current Expression)
That way, for your grand total, those lines will be null. They appear as a dash by default, but you can change that on the presentation tab.
If you are talking about the partial sum on something other than the first dimension, then you will need to edit your expression accordingly. You can figure out which dimensionality level you want by adding Dimensionality() as an expression on your chart.