Exclude a Dimension

[#1]

Hey guys.

How do you exclude a certain dimension. eg i have a bunch of sites or areas labelled site. in site, theres a area called South. now how do i select everything to show except for South? i tried the following but its not workng:

=if(isnull(Site='South','0',Site))

[Or · Accepted solution]

Check the 'Suppress when value is null" box and use:

if(Site<>'South',Site)

[#3]

Thanks man. I knew it was something simple i just couldn't remember. Thanks a bunch