TABLE: limit a dimension

Flaminio88 — Wed, 20 Oct 2021 15:08:11 GMT

Hello everybody,

I am building a simple table with column like SHOP NAME, CITY COUNTRY, so only dimensions.

I just need to limit this table to some specific value of the COUNTRY. So for example

SHOP NAME, CITY, COUNTRY

Shop1, Milan, Italy

Shop2, Madrid, Spain

Shop3, Barcelona, Spain

In my table, I want to see ONLY the shop with COUNTRY = SPAIN.

I have no measures inside. Is there any way to filter the table?

Thanks

Re: TABLE: limit a dimension

jmartineze — Wed, 20 Oct 2021 15:19:46 GMT

hello,

you can add a dimension like this if(COUNTRY = 'SPAIN', 'SPAIN')