Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?.
=Sum({<country = {'US','UK','Japan'}>} [net sales])
or you can try with this example:
=Sum({<country = {"US", "UK", "Japan"}>} [net sales])
Regards!
Hi,
another one:
=Sum({$<country={"(US|UK|Japan)"}>} [net sales])
hope this helps
regards
Marco
New learning for me marcowedel
So, compound search can be used in Set Analysis