Summarize Pivot Data by “Average” or some other formula
By default excel summarizes pivot data by “sum” or “count” depending on data type. But often you may want to change this to say “average”, to answer questions like “what is the average sales per product”.
To do this,
1) Right click on pivot table values (not on row or column headings) 2) Select “summarize data by” and
3) Select “Average” option or any other formula like Count, Max, Min, etc as needed.
Please feel free to ask any question in this regard