Pivot table summary functions

  • Thread starter Thread starter SB Lee
  • Start date Start date
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.
 
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.
 
Back
Top