Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ashwath26
Contributor II
Contributor II

Displaying Sales trend for Top rank Country

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

0 Replies