Restriction dimension values in chart

[#1]

I have to create a chart with country dimension and sum(net sales) as expression.

I have more than 10 countries in my country column  .

But in the chart i want to show sales of only three countries ie US, UK and Japan . How do i restrict my dimension values in the column?.

[swuehl]

=Sum({<country = {'US','UK','Japan'}>} [net sales])

[#3]

or you can try with this example:

=Sum({<country = {"US", "UK", "Japan"}>} [net sales])

Regards!

[MarcoWedel]

Hi,

another one:

=Sum({$<country={"(US|UK|Japan)"}>} [net sales])

hope this helps

regards

Marco

[Saravanan_Desingh]

New learning for me marcowedel‌

So, compound search can be used in Set Analysis