Pivot table

H

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
 
L

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.
 

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


Top