Add a new idea Subscribe
Status Shipped
Created by Chris Waters
Created on Aug 12, 2015

RELATED IDEAS

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. 

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
  • 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 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 

  • Linda Simek
    Reply
    |     Jul 18, 2017

    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.

  • Guest
    Reply
    |     Feb 2, 2017

    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!