| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table defaults
When adding numeric fields to the Values section of a pivot table, is there a
way to have the Value Field Settings default to Average rather than Sum? Seems like a lot of clicks are required to change every field individually. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table defaults
-- If this post helps click Yes --------------- Jacob Skaria "cturner08" wrote: When adding numeric fields to the Values section of a pivot table, is there a way to have the Value Field Settings default to Average rather than Sum? Seems like a lot of clicks are required to change every field individually. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table defaults
Sorry you cannot. If there are blank cells or cells with text the default
will be COUNT; or other wise it will be SUM. -- If this post helps click Yes --------------- Jacob Skaria "cturner08" wrote: When adding numeric fields to the Values section of a pivot table, is there a way to have the Value Field Settings default to Average rather than Sum? Seems like a lot of clicks are required to change every field individually. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table filed defaults | Excel Worksheet Functions | |||
| pivot table defaults to pivot chart | Charts and Charting in Excel | |||
| Pivot Table defaults for Excel 2007 | Excel Discussion (Misc queries) | |||
| function defaults change in Pivot Table..why? | Excel Discussion (Misc queries) | |||
| Pivot table, summary function defaults | Excel Discussion (Misc queries) | |||
Linear Mode
