not wildmatch in calculated dimension

[#1]

I have the following  calculated dimension to display only 'sales', 'corporate service', 'advertising & marketing' and 'logistics' in my bar graph: However I am left with a resultant bar which is all other values. How do I only show these 4 values and nothing else ?

=if(not wildmatch(tax_category, '*Sales*', '*Corporate Service*', '*Advertising & Marketing*', '*Logistics*'), null(),tax_category)

[sunny_talwar]

May be this:

=If(WildMatch(tax_category, '*Sales*', '*Corporate Service*', '*Advertising & Marketing*', '*Logistics*'), tax_category)

[sunny_talwar]

or

=If(Match(tax_category, 'Sales', 'Corporate Service', 'Advertising & Marketing', 'Logistics'),tax_category)

[sunny_talwar · Accepted solution]

Remember to check 'Suppress When Value Is Null' on the dimension tab

[#5]

Perfect - that's what I was missing.