Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-15-2019, 08:07 AM   #1
AlyKatVandy
Newly Registered User
 
Join Date: Jul 2019
Location: NY, USA
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
AlyKatVandy is on a distinguished road
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?

AlyKatVandy is offline   Reply With Quote
Old 07-17-2019, 03:40 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,227
Thanks: 512
Thanked 917 Times in 869 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
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
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 07-25-2019, 05:09 AM   #3
kilroyscarnival
Newly Registered User
 
Join Date: Mar 2002
Location: Orlando, Florida, USA
Posts: 50
Thanks: 1
Thanked 0 Times in 0 Posts
kilroyscarnival
Re: Top 10 Pivot Table

Quote:
Originally Posted by AlyKatVandy View Post
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.
Attached Images
File Type: jpg Picture1.jpg (38.8 KB, 8 views)

kilroyscarnival is offline   Reply With Quote
Reply

Tags
excel , pivot table

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Append data in an Access Pivot Table to a Table (or requery on it) Vagus14 Queries 2 01-22-2015 01:20 PM
No Pivot Table or Pivot Chart options? stoolpigeon General 6 11-03-2013 02:25 PM
Question Sync Pivot chart/Pivot table Filter msadiqrajani General 0 10-19-2012 05:26 AM
Changing (Editing) table values with Pivot table Chipcom Queries 0 04-13-2006 08:14 AM
create pivot chart from pivot table?? dhx10000 Tables 0 03-13-2006 04:11 PM




All times are GMT -8. The time now is 12:25 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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