+ Reply to Thread
Results 1 to 4 of 4

Sort by multiple column criteria within a pivot table

  1. #1
    Registered User
    Join Date
    05-12-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Sort by multiple column criteria within a pivot table

    Is there any way (simple sorting, calculated field, vba, etc) to be able to sort within a pivot table by multiple column values. My pivot shows rows as problems, then column values are counts of unique problems at each severity level. There are several problems per severity level. I want to be able to sort by severity level (so the highest severity problems are in the first column), then highest count of each within that level.

    Attaching excel file with an example base data, pivot, and final result. Right now, I am simply copying the pivot, pasting as values on a new sheet, then sorting as a regular excel file. This last sheet is what I send out to my engineers. If I only had to do one report, that would be an "okay" process; when it gets to be 10+, there has to be a better way.

    Any help would be appreciated.

    Kathy
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Sort by multiple column criteria within a pivot table

    Is this layout ok for you?

    See the sheet with the pivot table.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-12-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Thumbs up Re: Sort by multiple column criteria within a pivot table

    Thank you oeldere. That is a very simple solution...my engineers are used to seeing it one way which is why I was trying to keep it in the same format. (Engineers are not usually known for their flexibility lol...at least not mine!) HOWEVER, I am going to present this as my new format and see how much pushback I get.
    Thank you for helping me think outside the box.
    Kathy

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Sort by multiple column criteria within a pivot table

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

    It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table: Filter column with multiple criteria
    By tonelot in forum Excel General
    Replies: 8
    Last Post: 06-15-2015, 08:38 AM
  2. Pivot table with multiple levels to sort by?
    By tnovak in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 02-04-2014, 01:31 PM
  3. VBA to Sort Pivot Table (Specific Column)
    By AHFoddeR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2013, 02:39 AM
  4. Replies: 0
    Last Post: 11-11-2011, 04:10 PM
  5. Sort a Column of Dates in Pivot Table
    By Linny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-22-2005, 09:05 PM

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