| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table field settings default
How can I make the default field setting to Sum in the Summarized By section?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table field settings default
The only way is by making sure that all the data in that field is numeric. If
you have text or empty cells in that field, you'll get count. You may want to look at an addin that can help you (if you do it a lot): http://contextures.com/xlPivotAddIn.html (from Debra Dalgleish's site) Gator wrote: How can I make the default field setting to Sum in the Summarized By section? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table default settings | Setting up and Configuration of Excel | |||
| Pivot table value (field settings) | Excel Discussion (Misc queries) | |||
| pivot table field settings % of... | Excel Worksheet Functions | |||
| Pivot Table Field Settings Default value | Excel Discussion (Misc queries) | |||
| Pivot Table Field Settings | Excel Worksheet Functions | |||
Hybrid Mode
