When you add a numeric data field to the Values area in a pivot table, the summary function defaults to either Sum or Count. You can change that field to use one of the other summary functions, such as Average. The Average Function The Average function in a pivot table works like the AVERAGE function [...]

When you add a field to the pivot table Data area, it automatically gets a custom name, such as Sum of Units or Count of Units. Instead of “Sum of Units”, you might want the name to show as “Units”, so it’s easier to read and the column is narrower. Unfortunately, if you select the [...]