Skip to Main Content
Status Already exists
Categories Reports
Created by Guest
Created on Jun 17, 2019

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

  • Attach files
  • Admin
    Julie Price
    Reply
    |
    Jun 17, 2019

    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.