cancel
Showing results for 
Search instead for 
Did you mean: 

Need help displaying rank of records in report

Former Member
0 Kudos

Post Author: tpoland

CA Forum: General

I have a report that is contains summary information that needs to be ranked at the summary level based on performance.*note, this data is completely fictional

Company

Location

Dealer Volume

Walkin Volume

CarQuest

$100,000

$25,000

Walden

$10,000

$8,000

Young St

$20,000

$12,000

Main St

$70,000

$5,000

Napa

$80,000

$45,000

Walck

$15,000

$10,000

Ransom

$20,000

$22,000

Syracuse

$45,000

$13,000

So now ranking Dealer Volume and Walkin Volume I would end up with

Company

Location

Dealer Rank

Dealer Volume

Walkin Rank

Walkin Volume

CarQuest

1

$100,000

2

$25,000

Walden

$10,000

$8,000

Young St

$20,000

$12,000

Main St

$70,000

$5,000

Napa

2

$80,000

1

$45,000

Walck

$15,000

$10,000

Ransom

$20,000

$22,000

Syracuse

$45,000

$13,000

For the column of Dealer Rank I could use a Running Total but this would be defeated if the data were sorted in a different fashion. Manually entering the ranking isn't an option because there will be about 4000 summary records in this report. Any suggestions about how to proceed would be much appreciated.

thank you in advance,

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Post Author: tpoland

CA Forum: General

It took some work to accomplish it but I was able to get this to work by creating a comma delimited string of the companies sorted by rank, then using a function to determine their position in that string (an array was too short).

Thanks for the tip...

Former Member
0 Kudos

Post Author: yangster

CA Forum: General

Well this gets pretty ugly. there is no easy way to create a ranking formula.the dealer ranking you don't have to worry about since it is in your main report and you are sorting by it so you can just start a count that starts at 1 at the topwalkin ranks is another story, you'll need to create a subreport that contains the same summation and create a shared variable for the ranking which will pass it back to the main report

Former Member
0 Kudos

Post Author: tpoland

CA Forum: General

That allows me sort the records but how do I display the ranking?

Former Member
0 Kudos

Post Author: yangster

CA Forum: General

Use the group sort expert.Click on your summary field, then click on the group sort expert which is two buttons to the left of the selection expert.For this group sort: all then base it on your summary and you will have the ranking you desire.Default is ascending but you can check it to descending to get most sales ranking first.