Table Calculations Aggregation

Hi everyone,

I had a query about table calculations in Quicksight. I am showing the top 10 apps by users for each country in a table. I have a filter for countries.

When I select two or more countries in the filter, the top 10 apps displayed for each country are the apps having the maximum users combined across the three countries. Instead, I want to show the top 10 apps for each country.

Does anyone know a way that the top 10 calculations are done for each country in the table and not aggregated?

Please try ranking with partition on country and apply filter on this rank
Here is an example on showing Top N products by each country.

In the attached image you can see the difference between overall rank and rank by country.

Please let us know if this works.