Restrict ranks to Top 10

Dear Team,

I have used RANK() function to find out TOP Customers based on sales.

I have 100s of customers.

I need to restrict the numbers of Customers to 10 only. So that my report shows only TOP 10 Customers.

This will also help us to create a bar chart which will show only 10 Bars.

Could you please let know how can we achieve this?


you dont need to use rank function. You can just arrange data in descending order and in the settings select 10.

Please refer to this blog