2 Replies Latest reply: Feb 15, 2011 12:16 PM by Nick Borunov RSS

    Force exclusing of certain values from chart

      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!