[SB Lee[_2_]]

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.

[Shane Devenshire[_2_]]

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.