Default pivot table's to default to "Sum" rather than "Count"
I would like the default on pivot tables to go to "Sum" rather than "Count" or have an option for the user to select what the default is.
The default is already SUM as long as the data in the field is numeric. It changes to COUNT when there are text values in the data because we cannot SUM non-numeric data. The current behavior is the intended design.
5 commentsComments are closed
if the user could choose the default behaviour, that would be ideal. In recent releases, this is now "Sum", but I would prefer it to be "Average".
@Kenneth Barber - that is correct, but if the column has blanks and not all filled with zeroes then it defaults to Count.
Kenneth Barber commented
I thought that the default is Sum for numeric columns and Count for text?
I agree too. I would like to choose the default myself (in my case: sum)
I agree, this is a real annoyance for me as well.