Skip to Main Content

Share your product feedback

Status Future consideration
Categories Reports
Created by Karla Johnson
Created on May 20, 2021
Merged idea
This idea has been merged into another idea. To comment or vote on this idea, please visit A-I-10026 In Pivot Tables, allow multiple ways to calculate fields in the "Cells" section.

Allow Pivots to select different calculation for each cells field Merged

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., feature name), and also want to see the average % complete. Not having the ability to select a specific value to display for each field forces us to use dashboards to present these combined calculations but that is not user friend.