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. Read the rest of “Excel Tutorial: Changing the Function of a Pivot Table”