Pivot table - Change default summarise value field.

  • Thread starter Thread starter YY san.
  • Start date Start date
Y

YY san.

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
 
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
 
Back
Top