Pivot table

[hcacote]

Hi,

I have a pivot table in Excel 2007 that looks the following:


Product name 2001 2002 2003 Grand Total
AB 1 4 4 9
AC 6 7 3 16


Is there any way in Pivot table instead of reporting Grand Total, to
have the average across the 3 years ? Something like:

Product name 2001 2002 2003 Average
AB 1 4 4 9
AC 6 7 3 16


Thank you
Hugo

 

[London Taza]

Hi

Select the cell you want to average on your pivot table, Right-Click and
select "Field Settings". In the dialogue box that comes up select "Average"
in the "Summarise by:" list.

Hope this helps.