Show top n and the sum of top n

[Syahfira1]

Hi,

I would like to show top 10 , top 20 , top 30 of country based on sum of sales.

When I select top 10 , the chart should display me the top 10 countries and the total sales of that top 10 countries.

I have achieved part of what I want except showing the summation of the sales based on selected top n's. I would not able to show it when i use the table chart is because

1. The top is measured based on first column measure. 
2. It shows me the overall summation of sales regardless of the nth top selection.

Image above is what I have done so far. It shows me the top 10 of Past Due Cut of 30/06/2022 because its my first measure column.  Also, it shows me the totals amount for all countries but not for the top 10 only. 680 million is the total for all country not for the 10 countries

By default, Qlik will calculate based on the first measure column for top/bottom fixed number. Refer to image below 

This is my current formula

sum({<[Reporting Date.MasterCalendar.Date] = {"$(=vLatestDate)"}>}"Past Due")
-
sum({<[Reporting Date.MasterCalendar.Date]={"$(=date(addmonths(vLatestDate,-1)))"}>}"Past Due")

I want the table chart to show me the top 10 based on the MoM variation and Totals of the top 10 .

How I can make this work?

Your help is much appreciated.

[Syahfira1 · Accepted solution]

Hi, managed to get the formula for top 10 

sum({$<[Dimension]={"=rank(sum([measure]),4,1) <= 10"}>} [measure])