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