Share via

Default Setting for Pivot Tables

Anonymous
2018-07-18T19:51:09+00:00

I am currently using Office 2016.  In the values section of my pivot tables, I somehow changed the default from SUM to COUNT.  How do I change it back to SUM?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-07-19T02:03:03+00:00

    It is not possible to change default (and also have it changed inadvertently).

    Pivot table has its own inbuilt logic to decide whether to have SUM as default or COUNT as default. It makes its decision on the basis of available data in your data range on which pivot is based upon.

    In general, for number data, it chooses SUM as default and for non-numbers, COUNT.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-07-18T19:59:51+00:00

    Hi, i hope you're doing good today.

    Please take a look at this article and let me know if it helps.

    https://www.myonlinetraininghub.com/excel-pivot...

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    Regards.

    Was this answer helpful?

    0 comments