# Thread: Calculate Top 12 from each group and rank the group

1. Registered User
Join Date
Aug 2012
Posts
2

## Unanswered: Calculate Top 12 from each group and rank the group

My results database has about 10,000 records.
Each "GROUP" could have anywhere from 8 to 30 records.
I need to grab the top 12 records from each GROUP, grab the total of the top 12 records and then rank the group by that total

Example database
BOB 10
BOB 11
BOB 14
BOB 16
BOB 13
BOB 18
SAM 15
SAM 12
SAM 17
SAM 11
SAM 10
SAM 13
JOE 15
JOE 12
JOE 17
JOE 11
JOE 10
JOE 13
BILL 10
BILL 11
BILL 11
BILL 16
BILL 12
BILL 14
MIKE 11
MIKE 12
MIKE 10
MIKE 19
MIKE 11
MIKE 11
So the overall rankings would be
Bob = 82
Sam = 78
Joe = 78
Bill = 78
Mike = 78
For example, I will just assume we want the top 3 points
I need the REVISED RANKINGS to show
Bob = 34
Sam = 32
Joe = 32
Mike = 31
Bill = 30
Can someone point me in the correct direction to do this?

Regards,
David

2. Registered User
Join Date
Oct 2009
Location
221B Baker St.
Posts
486
Please show how the "top 3 points" was determined. I don't see how BOB was found to be 34.

I am probably missing something.

3. Registered User
Join Date
Aug 2012
Posts
2
I apologize. My example should be top 2

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•