pivot tables-data field formatting
 

How do I change the default data field type from Count to Sum?

I don't think you can.

If all the entries are numeric, you'll get Sum, but if any are text (or empty),
you get count.



popp25 wrote:

How do I change the default data field type from Count to Sum?

--

Dave Peterson

All of my entires are numeric, but my default settings do not give me Sum,
they default and give me "Count". I have to change each to Sum.

"Dave Peterson" wrote:

I don't think you can.

If all the entries are numeric, you'll get Sum, but if any are text (or empty),
you get count.



popp25 wrote:

How do I change the default data field type from Count to Sum?

--

Dave Peterson

I'd double check--maybe you have an extra row in your pivottable source range.

Maybe you have a cell formatted as text masquerading as a number.

If you select the cells and right click on the statusbar in the bottom right
corner, you can choose Count Nums and Count.

Are those the same quantity?

And do they match the number of cells in the selection? (empty cells cause
trouble.)

popp25 wrote:

All of my entires are numeric, but my default settings do not give me Sum,
they default and give me "Count". I have to change each to Sum.

"Dave Peterson" wrote:

I don't think you can.

If all the entries are numeric, you'll get Sum, but if any are text (or empty),
you get count.



popp25 wrote:

How do I change the default data field type from Count to Sum?

--

Dave Peterson


--

Dave Peterson