| 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 |
|
#2
|
|||
|
|||
|
Pivot Table Field Settings Default value
I think it was Deborah D. that answered this same question for me. If the
data contains blanks, is assumes that those are text, and does a count. If it is all numbers, then it uses sum. "MMesarch" wrote: 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 |
|
#3
|
|||
|
|||
|
Pivot Table Field Settings Default value
And there's no way to set the default.
Jonathan Cooper wrote: I think it was Deborah D. that answered this same question for me. If the data contains blanks, is assumes that those are text, and does a count. If it is all numbers, then it uses sum. "MMesarch" wrote: 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| 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) | |||
Linear Mode
