Results 1 to 5 of 5

Pivot table show top 10 Employee

Threaded View

  1. 04-18-2017, 03:09 PM #1
    janljan
    janljan is offline
    Registered User
    Join Date
    04-04-2017
    Location
    LEMONT
    MS-Off Ver
    Office 13
    Posts
    50

    Pivot table show top 10 Employee

    Hello,

    I have a pivot table where I need to show the manager then employee. Attachments include.
    If I have manager listed first, I can't seem to have a value filter on employee to show 10 top.
    What can I be doing wrong.
    Basically, I want to group by manager for the 10 to employees that have the most carry-over days.

    TIA,

    Kind regards,
    Jan
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. creating a pivot table from employee attendance data
    By omtamimi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-19-2017, 03:21 AM
  2. Show in a pivot chart only some sub-percentages from pivot table
    By kikonas in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-25-2016, 02:35 PM
  3. Show items in pivot table filter's drop-down list based on other filters of the same table
    By qwertyu_zxc in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-16-2015, 05:46 AM
  4. Pivot Report doesn't show current records but they are in pivot table
    By dixiecricket in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-16-2015, 11:25 AM
  5. [SOLVED] Pivot Table Summary -- Part #'s do not show in Pivot but data is in worksheet
    By maryren in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-19-2013, 10:51 AM
  6. [SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)
    By Gideon1973 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2012, 10:57 AM
  7. Pivot table show all
    By Barry Au in forum Excel General
    Replies: 0
    Last Post: 05-30-2007, 02:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1