Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Excel (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=55)
-   -   Top 10 Pivot Table (https://www.access-programmers.co.uk/forums/showthread.php?t=305887)

AlyKatVandy 07-15-2019 08:07 AM

Top 10 Pivot Table
 
Greetings! I work in a call center and am responsible for reporting on certain phone data. I have a separate pivot table with each agent, how many times they went into a specific phone state and how long they were in that state. I am trying to create a second table next to the first with the top 10 agents for the count of that state and the top 10 agents for the duration of being in that state. I am having trouble figuring out how to narrow the data down to the top 10. Any tips?

Uncle Gizmo 07-17-2019 03:40 AM

Re: Top 10 Pivot Table
 
A quick search of the forum for the search term top 10 returned the following results:-

https://www.access-programmers.co.uk...45&postcount=3

https://www.access-programmers.co.uk...29&postcount=5

https://www.access-programmers.co.uk...28&postcount=4

Another Forum:-
https://www.accessforums.net/showthr...958#post258958

kilroyscarnival 07-25-2019 05:09 AM

Re: Top 10 Pivot Table
 
1 Attachment(s)
Quote:

Originally Posted by AlyKatVandy (Post 1630879)
Greetings! I work in a call center and am responsible for reporting on certain phone data. I have a separate pivot table with each agent, how many times they went into a specific phone state and how long they were in that state. I am trying to create a second table next to the first with the top 10 agents for the count of that state and the top 10 agents for the duration of being in that state. I am having trouble figuring out how to narrow the data down to the top 10. Any tips?

Did you find a solution? I see Uncle Gizmo gave you some good links but those all seem to be MS Access solutions. If you have Microsoft Access as part of your Office suite, that's probably going to work best for you over time. You can set up your report options, and all you'd have to do is import your day's/week's data and run the report.

In Excel, it may depend on what version you have. At work I have Excel 2010. I made a basic pivot table, then clicked on the dropdown next to the "Row Labels" header, and look under the "Value Filters" option. Top 10 is the default, but it can be amended to Top/Bottom, and the n-value changed to 5, etc.


All times are GMT -8. The time now is 11:36 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World