Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
Is there a way to set a default on the pivot table field in the page area so
that when you drag items onto it, the field will always Sum? It's a real tedious job to have to double click and change from Count to Sum when you have a large number of fields. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
Nope.
But Debra Dalgleish has an addin that removes some of the time/sweat. http://contextures.com/xlPivotAddIn02.html john anderson wrote: Is there a way to set a default on the pivot table field in the page area so that when you drag items onto it, the field will always Sum? It's a real tedious job to have to double click and change from Count to Sum when you have a large number of fields. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
#REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |