Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Sorting a Pivot Table by value - Excel

    I have a Pivot Table

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,819
    Thanks
    133
    Thanked 480 Times in 457 Posts
    Well where is it then

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Sorry, I lost the text of my post.

    Here goes the Mulligan.

    I have a PIVOT TABLE which has the following fields:

    1.> Division
    2.> Dept.
    3.> Employee Name
    4. >Employee I. D. Number
    5.> Y-T-D Cumulative Over-Time (OT) Hours

    I need to Sort this PIVOT TABLE in the following manner.
    A. Total Division by largest to smallest OT Hours by the total of all Divisions
    B. Total Dept. by largest to smallest OT Hours within the Division
    C. Total Employee by largest to smallest OT Hours within the Dept.
    I would also like to include a PERCENTAGE OF TOTAL for each
    A. Individual Division OT HOURS as a Percent of Total All Divisions, in the data table, OT Hours
    B. Individual Dept. OT Hours as a Percent of Total l Dept. OT Hours that’s within it’s Division
    C. Each Employee OT Hours as a Percent of Total Emplyee OT Hours within it’s Dept.

    Thank you and sorry again for the mispost.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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