Last week we told you how to create a pivot table in Microsoft Excel. This week we expand your pivot table knowledge with a new tutorial: changing the function of a pivot table.
Changing the Function of a Pivot Table
When fields are placed in the Value area of a Pivot Table an assumption is made that a numeric field is to be added and a text field is to be counted, as shown below.
There are several functions you can use in a Pivot Table, Sum, Average, Max, Min, and Count. If you wish to change the function, click on the arrow to the right of the field, in the values box, and choose Value Field Settings.
Select the appropriate function from the Summarize box and click on OK.
Using more than one Function
Perhaps you would like to sum and average the data.
In the example shown, we would drag the Salary field a second time into the Values area. Notice the Column box, also shows Values, this is to indicate that the answer is to be shown in a Column.
Set the Value Field Settings for the second field to Average.
Finish it all off by changing the Column Headings to explain the data being viewed. Just type on top of them.