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:
country | product | sales |
Japan | type1 | 10 |
China | type2 | 11 |
Malaysia | type3 | 12 |
Vietnam | type4 | 13 |
Indonesia | type1 | 14 |
Thailand | type2 | 15 |
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
country | product | sales |
Japan | type1 | 10 |
Vietnam | type4 | 13 |
Indonesia | type1 | 14 |
Thailand | type2 | 15 |
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