Thread: Pivot table - Change default summarise value field.
View Single Post
  #2  
Old June 21st, 2009, 04:51 PM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
  
Posts: 5,952
Default Pivot table - Change default summarise value field.
Sorry you cannot. If there are blank cells or cells with text the default
will be COUNT; or other wise it will be SUM..

If this post helps click Yes
---------------
Jacob Skaria


"YY san." wrote:

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