LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe
 
Posts: n/a
Default Filtering a Top or Bottom 10 result set

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert number into words Blackwar Excel Discussion (Misc queries) 4 December 2nd 05 12:05 PM
I NEED HELP with the SPELLNUMBER Function vag Excel Worksheet Functions 0 June 21st 05 08:17 AM
EXCEL:NUMBER TO GREEK WORDS vag Excel Worksheet Functions 1 June 15th 05 05:57 PM
Is there a formula to spell out a number in excel? Sha-nay-nay Excel Worksheet Functions 2 December 18th 04 09:25 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"