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.
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.