Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Make Exp1 & Exp2 dimensiosns and just have a single expression, see attached.