Hide a dimension when expression value is 0

[Anonymous]

Hello,

I want to supress the dimensions if the expression value is 0.

I have a pivot table with more than one dimension and with one expression.

Thanks in adavance.

[MayilVahanan]

Hi

Did you try like this?

Presentation -> check the Suppress zero values checkbox.

[Gysbert_Wassenaar]

Enable the Suppress Zero-Values option on the presentation tab. Any rows where the expression value is zero will be suppressed.

[Chanty4u · Accepted solution]

enable supress zero values

chk below

Hiding Dimensions in Pivot Table