Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??????
hi,
you can use ISnull() function
and may be use conditional option
can you attached a sample application
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.
hi mohit thanks for the reply ... but can you please attach a sample application....
It will be a great help
see the attached file
in this already hide but if you uncheck in conditional expression then you 'll see that
hope it helps