Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
it may be possible only by macro not by chart expression
Hello,
just FYI in case someone is trying to do the same..
I solved it using IF(Dimensionality() ....)
Regards