Pivot Table - Limit Sum

[ChrisAnthony]

Hi Folks,

I have a DB that allows users to login and evaluate applicants for job position. This works fine. I now have a pivot table sums the scores of each user. This works fine. What I want to do is limit the results to the top 5 candidates with the highest scores

I am not sure how to do this. Any ideas?

Also I have another pivot table that shows each applicants average score for each criteria or question and I would like to limit this pivot to top five candidates based on the sum of all answers.

I am not sure how to do this. Any ideas?

Thanks,

Chris

 

[ChrisAnthony]

Also I went into the query for the pivot and tried changing to show top 5. The problem is that it shows the top five applicants in alphabetical order not based on the sum of the scores

 

[MMaynard]

When you changed it to top 5 in the query did you sort DESC by the scores field?