Allow Sorting Rows/Columns in the Pivot Table

Currently, the Pivot Table does not allow sorting column and row headings - everything is sorted in ascending order. We should use the same tech for sorting cell contents to allow sorting row and column headings.

  • Alex Bartlow
  • Oct 12 2015
  • Shipped
Release time frame 1 month
  • Aug 9, 2017

    Admin Response

    Today we have delivered powerful new sorting capabilities for pivot tables, charts, and custom roadmaps. You can now build the perfect report and organize the view exactly how you need it. Check out the blog post for more details.

  • Attach files
  • Travis Richardson commented
    October 12, 2015 23:54

    This is critical for us.  We have custom fields that imply a workflow order.  In some cases the naming requires a descending sort.  A simple case involves tagging products by strategic horizon (H3,H2,H1) where H3 is logically the first in a product or business lifecycle.  

  • Guest commented
    October 14, 2015 19:26

    Agree - crazy that timeline and pivots default to sorting alphabetically vs. allowing user to specify. For timelines, start date would be far more logical (as a start).

  • Guest commented
    March 18, 2016 17:43

    In one case, we want columns per release, and unfortunately the columns are sorted by Release Name instead of release date.  Currently there seems to only be sorting within each cell

  • Kenneth Yan commented
    June 30, 2016 17:43

    I see that there a quite a few votes. When will this be planned for release? This will be very useful.

  • Nick Mariette commented
    August 5, 2016 04:29

    This should apply not just to Pivot Tables, but also Timeline Reports.

  • Nick Mariette commented
    August 5, 2016 06:37

    I imagine this might work by enabling the row header to be dragged up/down, much like column headers can be dragged sideways in the table list views. At least that's how I'd love to be able to re-sort my Pivot and Timeline reports. I expect it might also be useful to provide a section to choose "sort by" criteria somewhere in the configuration area. 

  • Guest commented
    January 23, 2017 20:21

    This is business critical for us! Simply sorting in alphabetical order is practically useless as we need to report on release timeline. For example, I have upcoming releases that are at the bottom of my pivot table because they're name aptly appears towards the end of the alphabet. This not conducive to proper/accurate reporting from a product management perspective. To accommodate, I have to create a separate List report sorted by release date, which adds to confusion and clarity. 

  • Thomas Dhollander commented
    March 30, 2017 10:56

    A must have. Our releases appear in random order in the pivot tables

  • Beery Holstein commented
    April 13, 2017 20:50

    Just having the parking lot at the "end" would be great

  • Justin Adams commented
    May 25, 2017 17:12

    Is this feature still likely to be implemented? I would love to be able to sort my pivot table by the column or row headers so that I can order by date, status, etc...!

  • Marina Reyna commented
    May 25, 2017 17:21

    This is critical for us, too

  • Jonathan Mathews commented
    June 5, 2017 15:21

    +1 Critical for us

  • Marina Reyna commented
    July 14, 2017 13:42

    Is there an update on potential roll out?

  • Nikki De Micco commented
    July 24, 2017 19:41

    We have the same issue that release names in alpha order are not the order of the timeline

  • David McLean commented
    July 28, 2017 13:19

    Understandable that alpha sorting was MVP for this but this enhancement will massively improve the presentation of reports. I often feel reluctant to use them in management presentations because not having it sorted by some useful datum just looks sloppy. Can't wait to see this!

  • Nick Mariette commented
    August 9, 2017 23:39

    It is awesome to see this feature released. Thank you.
    Unfortunately it doesn't solve one of my sorting needs. I have a timeline report, in which I visualise release names and release dates for several releases of several products from several product lines simultaneously. It is quite a neat report, and one that gets used in high-level monthly reports. The only problem is that I can't sort the rows (with row headers showing product line and product names) in the way I need. On this report, some of my product lines are internal products that are dependencies of some other external products. I would like to put the rows with internal product lines at the top of my report, so the dependencies flow downwards. Unfortunately if the product line names were 'A', 'B', 'C', it turns out 'B' is the internal line. So there's no way I can sort (ascending or descending) to get the row for 'B' at the top of the report. What I need is arbitrary sort order (e.g. using those little grab bars that look like hamburger menus). Even if I were to make a custom field that creates the order I wanted, in other reports I might want to display using another apparently arbitrary order (that makes sense to me). Please add an arbitrary sort order in the report view itself.

  • Nick Mariette commented
    August 9, 2017 23:48

    I've added a new request here for the problem in my comment above. https://big.ideas.aha.io/ideas/APP-I-4936