TABLE: limit a dimension

[Flaminio88]

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

[jmartineze]

hello,

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