Changing the Value settings

When we add values to our pivot table, Excel’s default value field settings are set to SUM. However, there are often times when you need to find information other than sum. Such as Average, Min, or Count. We can quickly change the summarization to a different aggregation by using Value Field Settings.

To change the value displayed in the pivot table, right-click anywhere on the pivot table, and select Value Field Settings.

From Value Field Settings we can add a Custom Name to our Pivot table.

We can also change how the data is summarized. By selecting any of the options available under Summarize Value By, your pivot table values will update.

The summarize options have been taken from Excels standard functions and are:

• Sum
• Count
• Average
• Max
• Min
• Product
• Count Numbers
• StdDev
• StdVevp
• Var
• Varp

Also, in Value Field Setting you will find Number Format. It is from here that you would select the number formatting type for the entire pivot table. This is very useful when you want to set custom formatting or any other formatting of the values in the pivot table.