Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a pivot table. Some of the rows are actually headlines and shouldn't contain any sub-dimensions. Is there a possibility to exclude these rows from pivot functionality? And give these "head line" property within the pivot?
Edit: What if I want these head lines to contain the total sums but not the sub-dimensions?
Br
Chris
There is no standard functionality for this, however if you have a way to recognize these rows, you can use that to do some specific calculation (and/or formatting). For example, if there is a e.g.a field DimProperty you can use in your calculating expression:
if(DimProperty='Headline',If(Dimensionality()=1,MyCalcForTotal),NormalCalc)