Expressions in Pivot Table

[Anonymous]

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

[#2]

Hello Isabel,

you can use Dimensionality() and SecondaryDimensionality() as conditions in your expressions.

Regards

Darek

[Anonymous]

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

[#4]

Hello,

try with "Suppress Missing", "Suppress Zero" on Presentation Tab.

regards

Darek