Restrict ranks to Top 10

Technical queries
#1

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?

Thanks
Pushpal

#2

HI
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