Change default calculation for pivot table items
When I drag new items into the values section of a pivot table, they always default to the 'Count' calculation. In my work, it's almost always 'Average' that I want though, and I'm left dragging a bunch of items in and changing them one by one in the dropdown. Annoying.
So, I'd ask you to consider adding one or both of the following options:
1. Change the default calculation for newly added items
2. Allow changing of calculation for multiple items at once (this would be particularly good if it let me change all the options for multiple items together)
Either or both of these would save me a lot of time. Thanks!
I strongly support this proposal. This is a bug that reallly bothers me for years (sic!) - new numerical values added to the pivot table are always by default calculated as "Count", although >90% of users would probably like to see there a "Sum". Please (finally) do something about it. Thanks a lot in advance.
Kenneth Barber commented
I think that your first point should be "add an option to change the default calculation...". I, for one, usually use SUM and not AVERAGE.