ignore values from dimension and expressions

[anuradhaa]

I have a field called Country and i have display the sales of each month country wise(two dimensions)

say i have three countries A,B,C and now i want to ignore country C from my charts.

I want to ignore it from dimensions, expressions. but need to get Country feild when i need it.

How can i do that

Thanks

[its_anandrjs]

You can achieve this with different ways

1. Use calculated dimension

Ex:- If(Match(Country,'A','B'),Country) //and select suppress when value is null

2. By SET expression

Sum({<Country={'A','B'}>} Sales) //Here i assume Sales is metric field

[Anonymous]

If you want to completely remove one specific country do it in the load statement itself so that it will not be visible.

[anuradhaa]

Hi,

Here i want to use exclude C

I have use

=sum({<COUNTRY-= {'C'}>} SALESCOUNT) but doesn't work

pls help