Pivot table - Change default summarise value field.

[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

 

[Jacob Skaria]

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

 

[Dave Peterson]

Although you can't change how excel works, you can use a utility addin that
changes the count to sum:

http://contextures.com/xlPivotAddIn02.html
(from Debra Dalgleish)