View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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.