Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Pivot Table Top 25

Posted on 2014-11-18
4
Medium Priority
?
105 Views
Last Modified: 2014-11-18
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
0
Comment
Question by:Frank Freese
  • 3
4 Comments
 
LVL 27

Accepted Solution

by:
ProfessorJimJam earned 2000 total points
ID: 40450453
Right click on the value field and then select top 25
0
 

Author Comment

by:Frank Freese
ID: 40450493
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
 

Author Comment

by:Frank Freese
ID: 40450525
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
 

Author Closing Comment

by:Frank Freese
ID: 40450527
thank you kindly
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question