Link to home
Start Free TrialLog in
Avatar of kwarden13
kwarden13

asked on

Excel - Show Top 5 Pivot for Current Year Not Total

Hi-

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?
example_2.xlsx
Avatar of Edward Pamias
Edward Pamias
Flag of United States of America image

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
Avatar of kwarden13
kwarden13

ASKER

Sorry I meant show top 3.

The top 3 by 2016 is different then the total
Can you give me an example of how it should look?
I created a table and sorted....  See attached and Table Tab.
EES-of-example_2.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
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.
EE-of-example_2.xlsx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
What do you mean you were trying to get in one pivot? Once you open the file makes sure you select enable editing.
You said you wanted to see side by side examples? So which one did you like better the previous file or the last sample?
Considering the ask was not doable, the possible alternatives were shown in the Post ID: 41745131 and Post ID: 41747467.