How do you configure a PivotTable value field to use MAX instead of SUM?

How do you configure a PivotTable value field to use MAX instead of SUM?

• A. PivotTable Tools Analyze tab, Active Field group, Field Settings button. Select Max. Click OK.
• B. Right-click the value field, choose Summarize Values By Max
• C. Data > PivotTable > Change aggregation to Max
• D. Formulas > SUM

Answer: (A)

In a PivotTable, the value field’s calculation is determined by the summarization function. The default is Sum, but you can switch it to Max to display the largest value in each group. To do this, select the value field in the PivotTable, go to PivotTable Tools on the ribbon, click the Analyze (or Options) tab, and in the Active Field group choose Field Settings. In the dialog that appears, choose Max as the summary function and click OK. The PivotTable will now show the maximum value instead of the total. Some versions also let you right-click the value field and choose Summarize Values By > Max, which reaches the same result.

In a PivotTable, the value field’s calculation is determined by the summarization function. The default is Sum, but you can switch it to Max to display the largest value in each group. To do this, select the value field in the PivotTable, go to PivotTable Tools on the ribbon, click the Analyze (or Options) tab, and in the Active Field group choose Field Settings. In the dialog that appears, choose Max as the summary function and click OK. The PivotTable will now show the maximum value instead of the total. Some versions also let you right-click the value field and choose Summarize Values By > Max, which reaches the same result.