If condition

[NavinReddy]

Dear all,

I have fine business groups  

[New Wkly ]='GWM ,'GIM ,Architecture','Tech,Risk,'Application Services') ;

these filters i have But i want to use only two filters in Pivot Table

if(Wildmatch([New Wkly],'GWM ','GIM '),[New Wkly ])

I am Using This filter in Pivot table but im getting all Business Data

Could some one help to me solve this issue

Thanks In Advance

Niranjan

[Anonymous]

can you try if ([New Wkly]='GWM ' or [New Wkly]='GIM ',[New Wkly])..if this does not work please post your qvw file it would be easy to solve

[NavinReddy]

please find the attechment

and second chart im trying to filetering

Best Regards,

Niru

[maxgro · Accepted solution]

maybe

check Suppress When Value Is Null

in Dimension Tab for the calculated dimension

=if(Wildmatch([New Wkly HC Rpt Level 1],'GWM Operation','GIM Operation'),[New Wkly HC Rpt Level 1])