Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

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.

22 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Adam shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
declined  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

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 comments

Comments are closed An error occurred while saving the comment
  • Rob commented  ·   ·  Flag as inappropriate

    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".

  • Anonymous commented  ·   ·  Flag as inappropriate

    @Kenneth Barber - that is correct, but if the column has blanks and not all filled with zeroes then it defaults to Count.

  • Lander commented  ·   ·  Flag as inappropriate

    I agree too. I would like to choose the default myself (in my case: sum)

Excel for Windows (Desktop Application): PivotTables and Power Pivot

Categories

Feedback and Knowledge Base

(thinking…)