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,330
    Thanks
    3
    Thanked 218 Times in 201 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 08: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,330
    Thanks
    3
    Thanked 218 Times in 201 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
    828
    Thanks
    209
    Thanked 106 Times in 93 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.
    ~
    Dell Alienware Aurora R6 (new 2017)
    Windows 10 Home x64 1703; Office 365 x32
    GeForce GTX 1060; 16GB DDR4 2400
    256G SSD, 1TB HD

Posting Permissions

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