+ Reply to Thread
Results 1 to 5 of 5

Help with pivot table sorting

  1. #1
    Registered User
    Join Date
    03-05-2021
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    20

    Help with pivot table sorting

    Hello Experts, I am trying to figure out how it would be possible to sort a pivot table based on two columns. In the attached sample, I'd like to sort by "Count of Customer" (descending) and then by "Min. of Days Since" (ascending).

    Why does it limit you to one criteria, when there is no limit for regular tables? Your help much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Help with pivot table sorting

    You could put the Count Of Customer calc inside the table, and use it as a row label, and sort that.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    10-05-2017
    Location
    Altamonte Springs, FL
    MS-Off Ver
    Office 365
    Posts
    146

    Re: Help with pivot table sorting

    There is a limitation to pivot tables in that you can't sort values; only rows and columns. GlennUK's workaround I'm sure will work, but then you're adding data you were intending on calculating instead of manually working around the problem.

  4. #4
    Registered User
    Join Date
    03-05-2021
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    20

    Re: Help with pivot table sorting

    Quote Originally Posted by GlennUK View Post
    You could put the Count Of Customer calc inside the table, and use it as a row label, and sort that.
    Thanks for the suggestion, though in the actual data (this was a sample), the row labels need to be fixed to another category - client tiering. Are there other workarounds to sort a pivot table by multiple values criteria?

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Help with pivot table sorting

    This proposal employs Power Pivot.
    Three measures are produced:
    Count of Customer:=COUNTROWS(Table1)
    Min Days Since:=MIN([Days Since])
    Sort Field:=[Count of Customer]*1000-[Min Days Since]
    The Sort Field is used to sort the pivot table and may be hidden (as modeled in column R).
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Custom Sorting a Slicer for a table - not a pivot table
    By Melissalee71 in forum Excel General
    Replies: 1
    Last Post: 10-12-2018, 10:23 AM
  2. [SOLVED] Sorting a pivot table and data outside of the table
    By nicki_rae22 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-06-2013, 12:57 PM
  3. Pivot Table Sorting
    By christ.naveen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-07-2013, 06:44 AM
  4. Excel 2007 : pivot table sorting
    By Kolacube in forum Excel General
    Replies: 0
    Last Post: 03-24-2011, 03:30 AM
  5. Pivot Table Row Sorting
    By aschwalge in forum Excel General
    Replies: 1
    Last Post: 10-03-2010, 09:09 AM
  6. [SOLVED] pivot table sorting
    By ushah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10: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