Hide rows in Pivot Table

[Anonymous]

I want the hide rows in pivot able if exp3 is equal to zero

My Exp3 is substraction of Exp1-Exp2

I have table like this

Dimension       Exp1     Exp2     Exp3  (Exp1-Exp2)

A                     300        100        200

B                    100           50          50

C                    100        100             0

My result should be like this.

Dimension       Exp1     Exp2     Exp3 

A                     300        100        200

B                    100           50          50

Please help me to fix the issue.

[MayilVahanan]

Hi

You need to include the expression in all the three expression and tick the suppress zero values options.

Exp1:

=if(Column(3) <> 0, Exp1) or If( (Exp1-Exp2) <> 0, Exp1)

similarly to exp2.

[Anonymous]

Make Exp1 & Exp2 dimensiosns and just have a single expression, see attached.