Pivot table Exp hidding

[#1]

Hi guys

I have a pivot table in the attached format.....

I want to hide the Exp2, Exp3 for Budget , and Exp3 for 2011 Dimension value because its values are null .....

Is it possible to do ??????

[sujeetsingh]

hi,

you can use  ISnull() function

and may be use conditional option

[#3]

can you attached a sample application

[er_mohit]

hii

create a variable  and use that variable as per condition like

if(null1='  ',Null=0,Null=1)

here Null is my variableand null1 is fieldname.

if suppose you have data then else  condition  true or if not then it hide  that expression.

[#5]

hi mohit thanks for the reply ... but can you please attach a sample application....

It will be a  great help

[er_mohit]

see the attached file

in this already hide but if you uncheck in conditional expression then you 'll see that

hope it helps