If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Ranking Customers based on annual Sales

Started by kw, 19 Sep 2023 01:45:30 PM

Previous topic - Next topic

kw

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

cognostechie

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.