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
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
ASKER
Sorry I meant show top 3.
The top 3 by 2016 is different then the total
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
EES-of-example_2.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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
EE-of-example_2.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
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