Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Default Function in Pivot Tables
Whenever I create a pivot table and drag my data field to the "Data Area,"
the pivot chart uses the COUNT function rather than the SUM function. Is there any way I can change the default back to SUM? -- sternb |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Default Function in Pivot Tables
From Debra Dalgleish's Contextures site
(http://www.contextures.com/xlfaqPivot.html#DefaultSUM): You can't change the default settings for the data fields. If a field contains blank cells, or cells with text, it will default to COUNT. Otherwise, it will SUM. There's a feature that changes all the data fields to SUM, in my pivot table add-in, that you can download he http://www.contextures.com/xlPivotAddIn.html Hope this helps, Hutch "sternb" wrote: Whenever I create a pivot table and drag my data field to the "Data Area," the pivot chart uses the COUNT function rather than the SUM function. Is there any way I can change the default back to SUM? -- sternb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to turn off Sum on Pivot Tables by default? | Excel Discussion (Misc queries) | |||
Default Number Format - Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
Default Value to Zero in Pivot Tables | Excel Worksheet Functions | |||
How can I change the default way pivot tables summarize by | Excel Discussion (Misc queries) |