At various times (for reasons I can't explain) my pivot table data defaults to a 'count' rather than a 'sum' of my data. This is annoying. Can I make it always default to 'sum'?
You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
