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?