Pivot table summary functions
 

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.

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.