Ignore values from feilds

[anuradhaa]

Hi i have a field called country,

It has lot of values A,B,C,.. and don't know the exact list of values and it is continually growing.

I have a bar chart shows sales by month,Country

I don't want to display Country 'C' in this graph. But i want to load all data(can't elininate it in the script)

So i have use set analysis, but doesn't work

=sum({<COUNTRY-={"C"}>} SALESCOUNT)

please tell me how to fix this issue

Thanks

[anuradhaa]

No, not works

[Anonymous]

Red underlines is a bug. But it should say "Expression OK" and calculation should work. If not, try checking spellings of your fields.

[sasikanth]

HI

PFA

[anuradhaa]

Oh... Grate.  

It works.....

Thank You so much

[anuradhaa]

But, This doesn't solve my issue completely.

Because, when i put it and select selections chart doesn't behave arroding to selections.

Thanks

[anuradhaa]

HI,

I have used if statement and solve my issue.

Thank You for your help

[Anonymous]

Hi

Pls try this

=sum(sales) - sum({<COUNTRY={'C'}>} sales)

Regards,

Krishna

[sasikanth · Accepted solution]

Go with calculated DIm,

like if(CNTRY<>'C',CNTRY) and supress null values,

then try to make selections

[SunilChauhan]

may be you your

sum({$<COUNTRY-={"C"}>} SALESCOUNT)

or what exaclty you want. plz share sample

[anuradhaa]

Already shared a sample, anyway i have solved my issue by using if statement. Thank you for your help