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

    Pivot table sorting

    Is there a way to sort a pivot table by major pivot points to the largest smallest, for instance,

    Item 1 - Cost Group Item 2 - Cost Center within Group Item 3 - Product Description within the Cost Center Item 4 - lowest detail sales in units


    so for these four (4) items, I would like to see, the Cost Group with the largest sales in Units Decending Order; then each Cost Center with the Largest total of the Sales in Units Decending order; then each Product Description within each Cost Center with the Largest total of the Sales in Units Decending order.


    Thank you.

  2. #2
    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
    You can sort each field by the data field which I think accomplishes what you want.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I want to sort in the following manner:

    Item 1 - Cost Group Item 2 - Cost Center within Group Item -Largest total 3 - Product Description within the Cost Center -largest total in Item 4 - highest to lowest detail sales in units

    do I use the pivot sort?

  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
    Did you try it?
    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
  •