I see what you mean, but can it be done another way so that I don't have
twice the columns?

Data:

Project Labor Material Disposal

A Res. 10 50 10
B Res. 15 60 15

G. Total 25 110 25


I would like it to be:

Project Labor Material Disposal

A Res. 10 50 10
B Res. 15 60 15

G. Total 25 110 25
Average 12.5 55 12.5


"Shane Devenshire" wrote:

Hi,

Just add the calculated field to the VALUES area twice. Then change one of
the calculation to average using the Field Setting option.

I would give you a more specific answer if you showed us a sample of your
data.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RoofIL" wrote:

How can I create multiple grand totals in a Pivot Table in Excel 2007? For
instance, one Sum and one Average. I want to be able to see the total for
the column and also the average for the column. Is this possible on the same
table or do I have to make two seperate tables?