Thread: Pivot table - Change default summarise value field.
View Single Post
  #1  
Old June 21st, 2009, 03:58 PM posted to microsoft.public.excel.worksheet.functions
YY san.[_2_]
external usenet poster
  
Posts: 21
Default Pivot table - Change default summarise value field.
Hi,
By default, the summarise value field in the pivot tabel is always COUNT.
Does anyone know that this default, can it be change to SUM?
Thank you in advance