| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table "summarize" default
Many thanks Dave
"Dave Peterson" wrote: If there are any non-numeric values in that field (text or empty cells), then you'll see count. I've never seen a way to change the default. But Debra Dalgleish shares an addin that has lots of useful stuff in it: http://contextures.com/xlPivotAddIn02.html Neil Webber wrote: Whenever I use the "summarize" functionality within a pivot table, the default setting appears to be "Count". I nearly always want to use "sum". Is there a way that I can change the default setting to "sum"? Thanks for your help -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find the "Show Pages..." Pivot table feature in 2007? | Excel Discussion (Misc queries) | |||
| Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
| Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
| pivot table field summarize default | Excel Worksheet Functions | |||
| How to set the default "summarized by" of a data field to "Sum"? | Excel Discussion (Misc queries) | |||
Threaded Mode
