Need help displaying rank of records in report

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,