Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
No, not works
Red underlines is a bug. But it should say "Expression OK" and calculation should work. If not, try checking spellings of your fields.
HI
PFA
Oh... Grate.
It works.....
Thank You so much
But, This doesn't solve my issue completely.
Because, when i put it and select selections chart doesn't behave arroding to selections.
Thanks
HI,
I have used if statement and solve my issue.
Thank You for your help
Hi
Pls try this
=sum(sales) - sum({<COUNTRY={'C'}>} sales)
Regards,
Krishna
Go with calculated DIm,
like if(CNTRY<>'C',CNTRY) and supress null values,
then try to make selections
may be you your
sum({$<COUNTRY-={"C"}>} SALESCOUNT)
or what exaclty you want. plz share sample
Already shared a sample, anyway i have solved my issue by using if statement. Thank you for your help