expression "if pivot table is expanded"

[marikabi]

Hello,

I would like to define an expression in a pivot table which is visible only in the case that the pivot is expanded.

In case it's collapsed, I want that expression to be hidden.

Is there a way how to translate this condition into my expression?

Many thanks in advance

[andrei_delta]

Hi,

it may be possible only by macro not by chart expression

[marikabi]

Hello,

just FYI in case someone is trying to do the same..

I solved it using IF(Dimensionality() ....)

Regards