Lets assume some of the customer has same sum of sales. How the function know which one to display for top 10 or bottom 10?
Did you test it - see what it does - Rank unique will rank by sum of sales 2 are equal the secondary rank is alphanumeric by name
there are other ranking functions like rank_modified and rank and rank_dense - try them out and see how they differ
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks for reply. Please attach the workbook you have worked on
glad to help out
but its time for you do step up and give the approach a try
if you still have difficult post your book and I will review it
Have a good weekend
Ok thanks will try it