Skip to Content
0
Former Member
Jun 17, 2008 at 10:29 PM

Ranking using CR XI

23 Views

Hi,

I have a report where most of my data is grouped by Region and Office and i have running totals. The various formulas gives the totals for regions.

I would now like to rank the regions but not mix up where the offices are!

ie

Region Office Total Rank

South 135 2

London Southbank 45

Kensington 57

Marble arch 33

West Mids 140 1 Birmingham 80

Sutton Coldfield 70

Edited by: Bindu Modi on Jun 18, 2008 12:30 AM