| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table data field defaults to COUNT, would like it todefault to SUM
On Jan 16, 3:00*pm, HKaplan wrote:
Excel will generally default to Sum for a numerical field. *What is in the field you want to sum? This seems to have answered the question. The data are financial numbers downloaded from Essbase. For some reason the 0 (zero) values are formatted as text, while the numbers greater than or less than zero are formatted as numbers. Multiplying everything by 1 formats them as numbers, and then the pivot table behaves as you indicate. Thanks. Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Default - Count to Sum | Excel Discussion (Misc queries) | |||
| change 'count of' to 'sum of' in pivot table field | Excel Discussion (Misc queries) | |||
| pivot table field summarize default | Excel Worksheet Functions | |||
| Pivot Table: I want default to be sum & not count | Excel Worksheet Functions | |||
| Pivot Table Field Settings Default value | Excel Discussion (Misc queries) | |||
![Dave F[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
