Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am building a chart, which shows sales by country.
I would however like to exlude countries A - C. To do this I have added the following to my chart dimension:
= if([country] <>'A' and [country] <>'B' and [country] <>'C' ,[country]) .
and the related expression I am using is sum(sales).
Looking at the chart, countries A-C are summed up into one column, where the label country is "-", and the sales are summed up, which is not what I expected as I thought, these countries would be excluded from both the dimension and consequently also the expression would not apply to these countries.
Would be great if somebody could help me out on this one!
Thanks,
Adi
Under the Dimension, choose Suppress When Value is Null
Under the Dimension, choose Suppress When Value is Null
You should use conditional exclusion in expressions instead of dimensions.
See attachment.