I have attached a workbook with the data table for a pivot table.
My filters are:
My row is:
My value is:
Count of Medals
My column label is:
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.