+ Reply to Thread
Results 1 to 5 of 5

Sort Pivot Table by first and third column only

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    Canada
    MS-Off Ver
    Office365 32-bit
    Posts
    19

    Sort Pivot Table by first and third column only

    I have a price list set up on a pivot table. The pivot is grouped by product type (first column) followed by the SKU/ID and then by the product name. The remaining columns are not relevant to this question. Excel automatically sorts the pivot by Column 1 (Category), then by Column 2 (SKU), and then by Column 3 (Product Name). My problem is that I don't want the list sorted by SKU, just by Category and Product Name. Is there a way of doing this without having to create a separate rank column which I then will need to hide? I have tried changing all the other sort options available to no effect and, unfortunately, changing the column order is not an option for me.

    Thanks!
    Alex

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,606

    Re: Sort Pivot Table by first and third column only

    Please read the yellow banner... Thanks
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  3. #3
    Registered User
    Join Date
    10-01-2012
    Location
    Canada
    MS-Off Ver
    Office365 32-bit
    Posts
    19

    Re: Sort Pivot Table by first and third column only

    Sorry. Here is a sample file. Like I mentioned originally, is there a way to sort the pivot without having to resort to additional columns which will need to be hidden?
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,690

    Re: Sort Pivot Table by first and third column only

    Whilst you can sort 1st column and then 3rd then 3rd column items will be sorted within SKU.
    So if you had to Name items with the same SKU they would appear sorted.

    To get the sorting you require you would need to swap the field order to be
    Category Name SKU
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    10-01-2012
    Location
    Canada
    MS-Off Ver
    Office365 32-bit
    Posts
    19

    Re: Sort Pivot Table by first and third column only

    Thank you Andy, I suspected that this was the case but hoped that there was some sort of setting that would allow one to bypass the default sorting order

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1