Top 5 for each country

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.

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).

2 Likes