Summarize Pivot Data by “Average” or some other formula

Summarize Pivot Data by Average or some other formula

Summarize Pivot Data by Average or some other formula

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
Happy Excelling…

No Responses

Show all responses

Write a response