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?