pivot table data field defaults to COUNT, would like it to default toSUM


D

Dave F

I'm building a bunch of fairly wide pivot tables, with a couple of
dozen data fields.

When I drag and drop the pivot table data elements into the data
field, Excel appears to choose the count function by default; I would
prefer that it sum by default so that I don't have to manually change
this.

Is there a setting somewhere?

Dave
 
Ad

Advertisements

H

HKaplan

Excel will generally default to Sum for a numerical field. What is in
the field you want to sum?
 
Ad

Advertisements

D

Dave F

Excel will generally default to Sum for a numerical field.  What is in
the field you want to sum?

This seems to have answered the question. The data are financial
numbers downloaded from Essbase. For some reason the 0 (zero) values
are formatted as text, while the numbers greater than or less than
zero are formatted as numbers. Multiplying everything by 1 formats
them as numbers, and then the pivot table behaves as you indicate.

Thanks.

Dave
 

Ask a Question

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.

Ask a Question

Top