In Pivot Table - can sum be changed to average?

  • Thread starter Thread starter Katie B
  • Start date Start date
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.
 
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
 
Back
Top