Hide pivot table experssion if value is 0

[srinivasa1]

Hi im doing month on month difference for selected year i have used before function but its creates one xtra cols wiht 0 value can anyone guide me how i can hide that.

Have attached application

Thanks in advance.

[sushil353]

Hi,

please find  the modified app.

HTH

Sushil

[srinivasa1]

Hi,

Thanks for try.still it shows jan col i need hide that cols if all cols value are zero

[er_mohit]

hiii try this in expression tab of pivot table and

cheked on conditional  and in that write this expression

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

null1 is my field name

hope it helps

see the atached image

[srinivasa1]

Thanks.Its not working sir, i have attached my sample app in this thread.i need to hide cols if all value is 0. eg Jan cols

thanks