I would need the ability to sort a pivot report by values in calculated cells

Pivot tables in excel help me sort values based on calculated cells.

Example: count(field1) needs to be sorted from largest to smallest, I am not able to so it

We have regular internal meetings to understand how Aha tool can help us overcome the current challenges we are facing without Aha tool.

When excel allows this functionality I think Aha should definitely enable sorting based on calculated cells and this would help us share reports with other users

  • Guest
  • Jun 17 2019
  • Already exists
Release time frame
  • Attach files
  • Admin
    Julie Price commented
    17 Jun 16:05

    Thanks for submitting your idea!

    Just to clarify, are you trying to sort the cells section by the calculated value?

    When sorting in the cells section, you are actually sorting within each cell, not down the column. Once you have calculated the cell values, that means there will only be a single value in each cell. So there is nothing to sort within the cell itself.

    In that case, you would actually want to sort the rows and/or columns by the calculated cell values instead.

    Someone from our customer success team will follow up with you to help further.