Skip to Main Content

Share your product feedback

122 VOTE
Status Shipped
Categories Reports
Created by Alex Bartlow
Created on Oct 12, 2015

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.

Release time frame 1 month
  • ADMIN RESPONSE
    Aug 9, 2017

    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
      Drop here to upload
    • Nick Mariette
      Reply
      |
      Aug 9, 2017

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

    • Nick Mariette
      Reply
      |
      Aug 9, 2017

      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.

    • Guest
      Reply
      |
      Jul 28, 2017

      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!

    • Nikki De Micco
      Reply
      |
      Jul 24, 2017

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

    • Guest
      Reply
      |
      Jul 14, 2017

      Is there an update on potential roll out?

    • Jonathan Mathews
      Reply
      |
      Jun 5, 2017

      +1 Critical for us

    • Guest
      Reply
      |
      May 25, 2017

      This is critical for us, too

    • Guest
      Reply
      |
      May 25, 2017

      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...!

    • Guest
      Reply
      |
      Apr 13, 2017

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

    • Guest
      Reply
      |
      Mar 30, 2017

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

    • Guest
      Reply
      |
      Jan 23, 2017

      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. 

    • Nick Mariette
      Reply
      |
      Aug 5, 2016

      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. 

    • Nick Mariette
      Reply
      |
      Aug 5, 2016

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

    • Guest
      Reply
      |
      Jun 30, 2016

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

    • Guest
      Reply
      |
      Mar 18, 2016

      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

    • Guest
      Reply
      |
      Oct 14, 2015

      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).

    • Travis Richardson
      Reply
      |
      Oct 12, 2015

      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.  

    • +22
    18 MERGED

    Sorting a pivot table that totals the number of ideas submitted per user. The sorting here needs to be based on the count of ideas submitted by a User.

    I can create a pivot table that totals the number of ideas submitted per user, but sorting appears to be handled alphabetically even if you change the report to list a numerical count (as opposed to text names). This really is basic.
    Guest over 8 years ago in Reports 0 Shipped
    23 MERGED

    Ability to sort on a pivot table via the row (and not alphabetical)

    Currently in a pivot table if you have rows being returned and you may have multiple rows, we be ideal to decide which row you want to sort by rather than by default it sorts by the first row and alphabetical order. This isn't always appropriate w...
    Guest almost 9 years ago in Reports 0 Shipped