Results 1 to 11 of 11

Thread: Pivot Table

  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table

    Excel 2000. I have a database sorted by department. Within each department employees are sorted by last name. One column shows how many minutes each employee used his radio. I need the pivot table to show which employee used the most minutes within his department. I can get the max minutes but can't figure out how to include the employee's name who used the most minutes.

    Help me please.
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Pivot Table

    Attached find your workbook with a pivot table sorted the way I think you want it. To sort the name by minutes, double click on the Name field in the Pivot Table, select Advanced and in the AutoSort section click descending, and then choose Radio Minutes from the DropDown list.

    Hope that is what you want

    Andrew C
    Attached Files Attached Files

  3. #3
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table

    See attached -- done without pivottables. Is it an absolute requirement to use PT's?
    Attached Files Attached Files

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table

    This is very close to what I need - what I really really want is for the pivot table to only show the name of the person who used the most radio minutes without unselecting all of the other names. Any other suggestions?

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Pivot Table

    Click on the Name Field, select Advanced, and in the AutoShow options, select Automatic, Show Top 1, and in the Using Field drop down, select Radio Minutes. You might also click on the Dept Field, and set SubTotals to None.

    Andrew C

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table

    Perfect!!!! Have a great day. Send me details about the Excel Master Class.

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table

    Okay - I give up - when I click on the name field I see absolutely no "advanced" choice! What am I missing?

  8. #8
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table

    Details on Master class:
    go to <A target="_blank" HREF=http://www.iil.com>http://www.iil.com</A>
    Click on the left on "Browse our courses"
    Scroll down about 80% of the screen until you see
    The Masters Certificate Program in Microsoft Excel
    then click on Download brochure. Next class starts 9/24 -- it's 6 days, 2 days in a row for 3 months:
    9/24-25, 11/1-2, 12/6-7

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table

    You have to double click select "Advanced", click "automatic" under "auto Show Options" and then select "Top" and scroll the arrow down to"1". I did it for you and attached your file. Also, you have to double click on Dept and check off "none" for subtotals.
    Regards
    Stephen
    Attached Files Attached Files

  10. #10
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Pivot Table

    Sorry, I should have been clearer. Click on the Name Field of the Pivot Table.

    Another copy attached with directions.

    Andrew
    Attached Files Attached Files

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table

    Thanks again - perfect.

Posting Permissions

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