Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
If I have a pivot table with three dimensions and four expressions. If I collapse all of my dimensions, I still get values for my expressions for my first dimension. Is there a conditional formatting where my expressions do not reflect values if all my dimensions are collapsed?
Kind Regards,
Isabel
Hello Isabel,
you can use Dimensionality() and SecondaryDimensionality() as conditions in your expressions.
Regards
Darek
Hi Dariusz,
Thanks Dariusz, that was very helpful. Is it possible to collapse the headers for the expressions if the values for the expressions is null?
Thanks!
Kind Regards,
Isabel
Hello,
try with "Suppress Missing", "Suppress Zero" on Presentation Tab.
regards
Darek