In Pivot Table - can sum be changed to average?

K

Katie B

Customer wants averages from worksheet containing data. I have set up a
pivot table for him but it gives sum information. Can that be changed to
average instead of sum?

Thanks.
 
J

JulieD

Hi Katie

yes, right mouse click on where it says "sum" choose "field settings" and
choose Average.
to give him both sum & average - drag the data field on again and then set
one to Average and leave the other one at SUM.

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add more cols to a pivot table 5
Pivot table question 1
pivot table calculated field 1
Help Requested with Pivot Table 3
Sumproduct on Table with two criteria 2
Excel 2007 - Pivot Table - Conditional Formatting - % of Total 1
Pivot Table 1
Average of Subtotals in Pivot Table 0

Top