Good morning! friend
I am facing the same problem and I need your help
I try to display the first 10 sales per country in a Pivot table
so I added this expression in dimensions
and as a result I have
as you can see for 2010 it gives a result USA-> France-> germany and the logical order is USA-> France-> UK
Thank you for your answers
All you have to do is Create a chart with Customer name. Add expression as Sum(Sales).
Go to Sort. Keep Sum(Sales) with ascending in case you want bottom customer and Descending in cae you want Top Customer.
You can limit the number from Properties-> Presentation -> Max Number(1 -100) ->Set this to 8.
Hope this will help you