When you drag the number header into the data field it defaults to sum,
double click it and select average instead or if you already have sum in
your pivot, right click anywhere in the number column (Total column) and
select field settings, there you can also change to average


--

Regards,

Peo Sjoblom


"mikelee101" wrote in message
...
Hello,
I'm pretty much a Pivot Table idiot, so I might be overlooking something
horribly obvious, but I'm trying to have a "Grand Average" column and row
in
a Pivot Table instead of a "Grand Total." I see the Grand Total
checkboxes
in the Options dialog box, but I've yet to stumble upon a way to specify a
function other than Sum.

Is this possible? If so, can someone let me know how?

Excel2000.

If I didn't explain that clearly enough, let me know and I can give an
example. Thanks for the help.

Mike