Hello,
This is my first post so please let me know if I should be posting this anywhere else.
I'm trying to rank customers in a list and then in a crosstab based on their total annual sales but am not having any luck. Any advice on how best to proceed?
Here's the result of my "rank" query calculation and it only shows 2 customers giving them multiple ranks.
Rank - Customer - YTD Sales
10 - a - 8,477
3 - a - 16,954
2 - a - 25,431
2 - a - 33,908
6 - a - 42,385
3 - a - 50,862
4 - a - 59,339
3 - a - 67,816
5 - a - 76,293
7 - a - 84,770
3 - a - 93,247
2 - a - 101,724
1 - b - 126,846
1 - b - 151,968
1 - b - 177,090
2 - b - 202,212
2 - b - 227,334
3 - b - 252,456
1 - b - 277,578
3 - b - 302,700
Hi
The information you provided is not sufficient to understand how exactly are you ranking them. What's the expression you used in the 'Rank query calculation' ? How is your data structured?
Normally, in this case, you would have to summarize the data, take the data into another query and then rank it because rank would need the totals to determine the rank. It cannot be applied at the line level.