Ability to sort on the Pivot Table

I have a numeric custom Feature field Priority. When I include it in a new pivot table, Aha! sorts the field alphabetically not numerically.

ADDED: Ability to sort in general so that you can change the order in which columns (data) are ordered from low to high or high to low, early to later, latest to earlier, etc. 

  • Chris Waters
  • Aug 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
  • Brian Collins commented
    February 2, 2017 23:39

    Our team would like to sort the # of Ideas promoted to a Feature in a Pivot report.

    Our current workaround is to copy paste the data to a spreadsheet, and then manually move this data, then sort.

    Thanks!

  • Linda Simek commented
    July 18, 2017 17:35

    I'd like this as well. I want to see the total number of votes for merged ideas but once I show the total votes I can't sort highest to lowest in the pivot table.

  • Nick Mariette commented
    August 9, 2017 23:50

    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 to. 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 (although it that makes sense to me). Please add an arbitrary sort order in the report view itself.

    I've added a new request for this here: https://big.ideas.aha.io/ideas/APP-I-4936