Table Calculations Aggregation

[Shalini_Sharma]

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?

[n_vetri]

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