I created a Rank column and a custom measure. I've filtered on Rank to show less than 11, so basically show me the top 10.
The custom measure is basically saying to show me when rank <= 5, then show Amount else Others.
Instead of "Others", is there a way to sum up the Amount value and end up only showing 6 rows. First 5 rows shows the top 5 countries, and then the 6th row sums up the countries that are ranked from 6 to 10.