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