Pivot Table Data Formatting.

[Mattlynn via OfficeKB.com]

Hi there
On a Pivot tabe layout, you have a section for Data, Page, Column & row.
When i build a pivot table , the numbers in the "data" section of the pivot
always default to a "Count" format.
Can we change the default to be sum ?
Thanks very much
Matt

 

[ShaneDevenshire]

Hi,

This happens because at least one cell in the data source field contains
either text or is blank. This is Excel's default behaviour. If all the
cells are numeric the default calcualtion is SUM.
You can't change this default, but you can always change the calculation
while creating the PT or afterwards. I suppose you could write VBA code to
do the conversion automatically.

 

[Mattlynn via OfficeKB.com]

hey - Thanks Shane

Hi,

This happens because at least one cell in the data source field contains
either text or is blank. This is Excel's default behaviour. If all the
cells are numeric the default calcualtion is SUM.
You can't change this default, but you can always change the calculation
while creating the PT or afterwards. I suppose you could write VBA code to
do the conversion automatically.

Hi there
On a Pivot tabe layout, you have a section for Data, Page, Column & row.

[quoted text clipped - 3 lines]

Thanks very much
Matt