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?