Pivot table summary functions

S

SB Lee

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.
 
S

Shane Devenshire

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.
 
Top