Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am showing a table on a measure, and I was wondering if there is an easy way to add a filter on it please. On the table below, I have country defined as a measure ( it does not work as a dimension), but i would like to filter on it.
country | sales |
Japan | 10 |
Vietnam | 11 |
Malaysia | 12 |
China | 13 |
Thanks for the help.
Hi,
Do you mean you want to filter your expression for some specific contry?
If so, you can use set analysis and as an example, if you want the sales for Japan only, you could do:
sum({<country={"Japan"}>}sales)
Felipe.
or u can create a new filter/dimension in ur presentation as a master dimension, as follow:
if(country='Japan',country,null())
name it as u want; and drag it a new filter