Top 5 for each country

[tyler]

Whats the best way to get the top 5 stores according to sales in each country.

I have a transactions table that has a transaction ID, purchase amount, store name/number, and some additional geographical data that includes the store country.

[kristian]

Hey @tyler!

Follow these simple steps to get the top 5 stores according to sales in each country:

1. Group the store_country column
2. Add a sales column on the same level as store_country using the formula: Sum([purchase_amount])
3. Use a limit filter on the sales column to limit the results to the largest 5 by rank (see image below).