Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
please find the modified app.
HTH
Sushil
Hi,
Thanks for try.still it shows jan col i need hide that cols if all cols value are zero
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
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