Pivot Table collapsed/expanded indicator?

[danielact]

Is there a way to indicate whether a dimension is expanded or collapsed in a Pivot Table? Can it be used in another dimension, or only in an expression?

[Anonymous]

yes,in pivot table , in the presentation tab select allow pivoting and unselect the option always expanding

[danielact]

I didn't mean a visual indicator, I meant something that can return a true or false value.

[chematos]

Dimensionality() function returns the number of dimensions expanded, I think you could use it to get near to your purpose

[danielact]

Dimensionality won't work in a dimension, only in an expression. It also won't tell you which field was collapsed.

[chematos]

Sorry, I didn´t undesrtand your question.

I don´t know how to make that, but I supose you need to get the properties of the object where the dimension is and may be with GetObjectField() you could get something but I don´t really know if is possible to do it .....

Good luck