In Pivot Tables, allow multiple ways to calculate fields in the "Cells" section
If you build a Pivot and add multiple fields to the Cells section, you can only calculate the fields by a single way (i.e. Sum, Count, etc.). We would like to add two (or more) fields to the Cells section and calculate them differently. For example, we would like to calculate the Feature ID by "Count record" and calculate a custom numerical field by "Sum." Right now, you can only select a single way of calculating.
3
MERGED
Allow Pivots to select different calculation for each cells field
Currently, when creating a pivot, you can select what to present for the fields in the cell. This could be list, count, sum, average etc. Often, we need a different display for each field. For example, I want to see the count for one field (e.g., ...
0
Future consideration
© 2025 Aha! Labs Inc.•All rights reserved
Being able to calculate "Cell" fields multiple ways would be incredibly helpful for us in creating reports that can be used by our teams. For our use case, we have a pivot table that shows the different orgs that have voted on particular ideas. We want to be able to list information on the Organization record while summing votes totals and other custom fields on the Proxy Votes object.