Pivot table summary functions
Hi,
Yes, just drag the same field to the data area more than once and then
change the calculation of one of the fields to average.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"SB Lee" wrote:
Is it possible to use more than one summary function on the same data field
in a pivot table? For example, I want the total as well as the average on a
bonus field.
Thanks.
|