Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to plot a chart on a limited data. Here is an example. in the database, i have a table that looks like:
I would like to plot Sales by country where product is different from type 2 and type 3, meaning i would like to limit the chart to this table
Could you please suggest an expression to do this. thanks very much.
Set Analysis Expression -
=Sum({$<[Product]-={'type2','type3'}>} Sales)
Normal Expression
=If(Not wildmatch(Product ,'type2','type3'), Sum(Sales))
Supriya