View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tara1 Tara1 is offline
external usenet poster
 
Posts: 1
Default Pivot Table: Summing Average Values

I am doing a pivot table where the values are displayed as averages. The
subtotal line is then taking the average of all of the rows. I would like for
the subtotal to be the sum of all of the rows but cannot figure out how to do
it.

Thanks!