Hi,
I want to display the sales in a country over different months. I have used the query below but getting an error. Pls provide the right query
sum({<Country={=rank(aggr(sum(Sales),Country))=1>}Sales)
I am not using Dimension limit as i am also planning to re use the query to display the Sales trned over months for country with second rank in terms of Sales