default pivot tabel from count to sum


Z

zeiny

Everytime I create a pivot table, it defaults to Count. I don't use count.
I always use sum. Can this be changed somehow?
 
Ad

Advertisements

T

trip_to_tokyo

EXCEL 2007

Pivot Table Data Crunching for Microsoft Office EXCEL 2007 by Jelen /
Alexander page 292 states:-

“MY PIVOT TABLE ALWAYS USES COUNT INSTEAD OF SUM

You have a column in your data source that contains numbers.

Furthermore, you have explicitly formatted that column to be a number field.

Nevertheless, each time you try to add it to your Pivot Table EXCEL
automatically tries to use Count on the field instead of Sum.

This leaves you manually changing the calculation method to Sum.

SOLUTION

If there are any text values in a source column EXCEL automatically applies
Count to the data field for that column. Similarly even one blank cell causes
EXCEL to apply Count.

It is likely that in your source column you have either a text value or a
blank.

To alleviate this problem simply remove both text and blank values from the
source column and refresh the Pivot Table.â€

If my comments have helped please hit Yes.

Thanks.
 

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