Pivot Table Data Formatting.
 

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

--
Matt Lynn

Message posted via http://www.officekb.com

Pivot Table Data Formatting.
 

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.

--
Cheers,
Shane Devenshire


"Mattlynn via OfficeKB.com" wrote:

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

--
Matt Lynn

Message posted via http://www.officekb.com

Pivot Table Data Formatting.
 

hey - Thanks Shane

ShaneDevenshire wrote:
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

--
Matt Lynn

Message posted via http://www.officekb.com