Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2013
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How Do I Sort a Pivot Table on Grand Total with Multiple Columns?

    My "Pivot Table" (model attached) has many columns of data. I had to blank out some fields due to sensitive nature of data. Either way, I think you can see my gist. I am looking to sort in descending order based on the Grand Total column. How to do this?

    Many Thanks!

    Mitch
    Attached Files Attached Files

  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 need to sort the plant field using the values data. Right-click the plant field, Sort - More sort options)
    Last edited by rory; 2016-10-13 at 09:52.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Lounger
    Join Date
    Jan 2013
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I tried. I don't think this will work or can you add more detailed info on how to execute this?

  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
    As I said - right-click the Plant field, choose Sort, then 'more sort options' and choose to sort using the value field.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    5 Star Lounger Lugh's Avatar
    Join Date
    Jun 2010
    Location
    Indy
    Posts
    627
    Thanks
    168
    Thanked 77 Times in 68 Posts
    Quote Originally Posted by mitch06251962 View Post
    My "Pivot Table" ... sort in descending order based on the Grand Total column. How to do this?
    Click in the GT column.
    Click Home tab, Editing section [far right], click the Sort Arrow, Click on the Z-A choice.

    Are you sure that's a pivot table, doesn't look like my usuals. However, above works for a normal table too.
    Lugh.
    ~
    Windows 10 Pro x64 1607; Office 2016 (365 Home) x32; Win Defender, MBAM Pro

    ASRock H97 Anniversary; Xeon E3-1231V3 (like i7)
    Gigabyte GeForce GTX 970; 12GB Crucial DDR3 1600
    Logitech MX Master mouse; Roccat Isku kb

Posting Permissions

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