Top 5 for each country

tyler · July 31, 2020, 4:19pm

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 · July 31, 2020, 4:54pm

Hey @tyler!

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

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

system · October 11, 2020, 9:46am

system · October 24, 2020, 5:21pm

system · November 9, 2020, 2:50am

system · November 28, 2020, 8:29pm

system · December 18, 2020, 3:56am

system · January 7, 2021, 2:10am

system · January 27, 2021, 11:01am

system · February 17, 2021, 8:38pm

system · March 11, 2021, 1:30am

system · April 1, 2021, 10:46am

system · April 23, 2021, 12:42am

system · May 14, 2021, 8:06pm

system · June 6, 2021, 2:34am

system · June 28, 2021, 11:07pm

system · July 21, 2021, 3:35pm

system · August 13, 2021, 11:55am

system · September 5, 2021, 11:48pm

system · September 29, 2021, 10:19am