I am working on a pivot table in Excel 2007 and I was curious if there is a
way that you can change it from summing to average. I have a lot of fields to
change from sum to average and I was wondering if there is a way to avoid
changing them individually...pretty simple question. Thanks in advance.

In your pivottable field list box, in the values section. Click on the item
you want to change. It will bring up a box, then click on "value field
settings". Here you can change it from Sum to Average.

--
If this has helped you, please click Yes

Thanks,
Megan


"Confusicous" wrote:

I am working on a pivot table in Excel 2007 and I was curious if there is a
way that you can change it from summing to average. I have a lot of fields to
change from sum to average and I was wondering if there is a way to avoid
changing them individually...pretty simple question. Thanks in advance.