Hidding a Expression based on Dimensionality

[azimabadi]

Hi all,

i have a pivot with 3 dimensions.

there is a expression that i need to show only when the 3rd dimension is expanded.

in condition of expression, the return value of Dimensionality() is always 0, that means i cant use here the function.

i will appreciate any idea.

Best Regards

Peyman

[RedSky001]

Have you tried, secondarydimensionality()

Taken from the help file:

returns the number of dimension pivot table rows that have non-aggregation content. i.e. do not contain partial sums or collapsed aggregates. This function is the equivalent of the dimensionality() function for horizontal pivot table dimensions.

The secondarydimensionality() function always returns 0 when used outside of pivot tables.

[Gysbert_Wassenaar]

See attached qvw. Is that what you're trying to do?

[azimabadi]

Hi Gysbert,

this is what i'm doing. but Client wants when there is no data in first column ( expression ), that means when all Regions are colapsed, i hide it ( the first expression ).

I#m not sure that it is posible.

Regards

Peyman

[azimabadi]

Hi Mark,

this is useful when you have horizantal dimensions in pivot.

Regards

Peyman

[Gysbert_Wassenaar]

No, hiding the expression column completely depending on the expanded/collapsed state of dimensions is not possible.

[#7]

Hi, maybe you find a solution? that's exactly the problem i'm facing...