Excel - Show Top 5 Pivot for Current Year Not Total


I have the attached workbook and would like to show top 5 for the current year not total. For example, in current workbook the top 5 for 2016 is company 4 , company 3, company 5.

However, when doing the top 5 the following are shown: company 2, company 5, company 1.

Can this be done in the pivot?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Edward PamiasTeam Lead RRS DeskCommented:
Do you want it to look like this??

Client      (All)      
Count of Sales      Column Labels      
Row Labels      2016      2015
Company 5      3      3
Company 4      3      
Company 1      3      4
Company 3      3      3
Company 2      2      4
kwarden13Author Commented:
Sorry I meant show top 3.

The top 3 by 2016 is different then the total
Edward PamiasTeam Lead RRS DeskCommented:
Can you give me an example of how it should look?
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Edward PamiasTeam Lead RRS DeskCommented:
I created a table and sorted....  See attached and Table Tab.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
I have inserted another pivot table along with a slicer to pick a year. See if this is what you are trying to achieve.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kwarden13Author Commented:
Hi Subodh-

This is what I want except now I want to be able to see how they did year over year. So its fine to select the year but how do I compare to 2015?
Edward PamiasTeam Lead RRS DeskCommented:
Check out sheet 2. I added the top 3 for 2016 and 2015 and a name range so when you add more data just refresh the pivot and it will up date the top 3.
Edward PamiasTeam Lead RRS DeskCommented:
I did one pivot with years side by side.
kwarden13Author Commented:
I was trying to get it in one pivot. I am guessing that is not doable. In the last example, it shows top 3 by total spend (for years 2015 and 2016). Not just the latest year.

It's odd you can't select which year.
Edward PamiasTeam Lead RRS DeskCommented:
What do you mean you were trying to get in one pivot? Once you open the file makes sure you select enable editing.
Edward PamiasTeam Lead RRS DeskCommented:
You said you wanted to see side by side examples? So which one did you like better the previous file or the last sample?
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Considering the ask was not doable, the possible alternatives were shown in the Post ID: 41745131 and Post ID: 41747467.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.