RELATED IDEAS
Merged idea
This idea has been merged into another idea.
To comment or vote on this idea, please visit A-I-10665 Pivot changes - adjust calculation row and/or column independently.
Having different calculation methods on pivot tables by 'row' and 'column'
Merged
Currently if you select 'Calculate' method for a pivot table it applies it to both row and column, however this isn't always logical.
In the example of selecting 'difference' you might want the difference at a row level to show difference between 'Feature original estimate' and 'feature logged effort'. However at the column level I would want to see all the times 'summed' for:
- Feature original estimates
- Feature logged effort
- Difference summed up
Therefore, could we please be able to control the 'Calculate' on a pivot table for column/row independently.
Thanks
Daniela
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- +1
© 2025 Aha! Labs Inc.•All rights reserved
We have a list of ideas in a pivot table and we want to also show in the columns vote count, org count, and ARR. The latter pulled from salesforce integration. We want to then change the filter based on a specific date field which is also tied to salesforce integration data (churn date). We can do this with vote count and ARR in the columns as sums. However, if we put the org count, since it is locked to "sum" then this value is not correct. We want this value to be "count unique records". By defining how each column has the "Within cells list as" then we can have more granular ability. I'm surprised this isn't a common request since I would think many people would want to know ideas by vote count, org ARR, and # of orgs associated to that idea and being able to filter by relevant churn dates
Just being able to hide the total column, leaving a total row at the bottom, would be super useful.
Please add this functionality soon as well as the ability to display $ sign when totaling values in a pivot report.
This would be really useful, because as it currently stands it does not make sense logically.