Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My Pivot Table works great including the Top/Bottom 10 feature.
However I need to filter out agents that have a total of less than "x" hours accumulated.... Let me explain. I have three columns: 1. Log Time, 2. Break Time, 3 Productive Time Productive Time = Log time - Break Time. I perform a Top or Bottom 10 based on "Transfers per hour" based on some other calculations. However, in my Pivot Table I need to see just those records of the agents that have a minimum of "x" Productive Hours. Currently my Productive Hours field item is in the "DATA area of my pivot table and AGENT is in the ROW area. Thank you for any assistance. Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert number into words | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |