Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I have Pivot Table with following columns
Note Amount
100 500
101 100
102 300
103 600
104 400
105 200
.... ....
I want to restrict display of dimension note 100,103,105. I want to do this without manually selecting from a list box. Pls help me to do it
Try in dimension : if(wildmatch(Note,100,103,105),Note)
Try in dimension : if(wildmatch(Note,100,103,105),Note)
Hi,
USe calculated Dimension,
Try like
if(wildmatch(Note,'100','103','105'),Note)
And select Supress Null Values in Dimension tab
Regards
Hi ,
In the dimension use the below expression
=IF(Note <>'100' and Note <>'103' and Note <>'105',Note)
Please find the sample application in the attachments.....
Thanks all