Restrict Dimension

[upaliwije]

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

[marwen_garwachi · Accepted solution]

Try in dimension : if(wildmatch(Note,100,103,105),Note)

[PrashantSangle]

Hi,

USe calculated Dimension,

Try like

if(wildmatch(Note,'100','103','105'),Note)

And select Supress Null Values in Dimension tab

Regards

[Anonymous]

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.....

[upaliwije]

Thanks all