| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - standard Data Field function
Hello
Is there some way to set the standard function for data fields when creating a pivot table? Normally it is Sum, unless the Pivot Table doesn't recognise the numbers and suggests Count. I would like average to be the standard - is this possible? -- Thanks very much. KDJ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables - standard Data Field function
No, you can't set the default summary function for the pivot table data
fields. KDJ wrote: Hello Is there some way to set the standard function for data fields when creating a pivot table? Normally it is Sum, unless the Pivot Table doesn't recognise the numbers and suggests Count. I would like average to be the standard - is this possible? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value Field Settings for Pivot tables | Excel Worksheet Functions | |||
| Pivot Tables - Field Error | Excel Discussion (Misc queries) | |||
| Pivot tables and Standard Deviation | Excel Worksheet Functions | |||
| Finding unique items in data field for pivot tables | Excel Discussion (Misc queries) | |||
| pivot tables-data field formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
