Question: how to find the average in a pivot table?
Answer: Click on the drop down arrow on the field and select "Value Field Setting." Select "Average" and click "OK." The pivot table is updated to display the average values for the fields selected.