Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting lost in a Pivot Table after a data refresh | Excel Worksheet Functions | |||
Date formatting on a Pivot Chart's Data Table | Charts and Charting in Excel | |||
Presever formatting on Data sheet in Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
Pivot Chart - Formatting Axis on Data Table | Charts and Charting in Excel |