Pivot Table Top 25

Folks,
I have attached a workbook with the data table for a pivot table.
My filters are:
Season
Team
Year
My row is:
Athlete
My value is:
Count of Medals
My column label is:
Medal

I am sorting the Grand Total from Largest to Smallest.
Here's what I can not get the pivot to report:
I want to show only the top 25 athletes for any year based upon the medals won.
I used the filter Season - All; Team - All; Year 2012 and I am getting more than 25.
Olympics.xlsx
Frank FreeseAsked:
Who is Participating?
 
ProfessorJimJamCommented:
Right click on the value field and then select top 25
0
 
Frank FreeseAuthor Commented:
Help me here please. When you say "value field" are you referring to a value in the pivot table itself of the field list?
0
 
Frank FreeseAuthor Commented:
I found my problem. I was only considering the top 25 on count medals and there are many count medals with 3. So I need to work on my criteria. Thanks for the help
0
 
Frank FreeseAuthor Commented:
thank you kindly
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.