| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Table Field Settings Default value
Hi,
When you drag an item from the field list into the pivot table, how does EXCEL decide what field setting ( Count, Avg, Stdev) to use. Sometimes it choses Sum and sometimes it choses Count, even in the the same pivot table. I would like to set it to always use average or stdev as a default. Thanks. -- Mark Mesarch School of Natural Resources University of Nebraska-Lincoln |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table for survey results with set of possible answers in PT's Rows Field? | Excel Discussion (Misc queries) | |||
| caluclated field in pivot table? | Excel Worksheet Functions | |||
| Calculated field in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Page Field | Excel Discussion (Misc queries) | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Threaded Mode
