In the Sort tab you can sort in descending order your customers using an expression like sum(Sales) and then in the Presentation tab enable the option to show a maximum of 10 or 15.
In the Sort tab you can sort in descending order your customers using an expression like sum(Sales) and then in the Presentation tab enable the option to show a maximum of 10 or 15.
You could also use the rank function in a table object...
rank(sum(sales),0,1)) will produce a statistic with ranking of the clients by "sales". That way you would have a list of clients and you can have their ranking right beside them. check out the rank function. There are different "modes" you can use. the modes i have used above will show ties as the same rank. So if there were two clients that had the same sales (given your current filters) they would both be reprsented as a ranking of "2".
