How to fix the value on pivot table field always as Sum

[wiewie002]

Dear Friends,
I would like to fix the the value on pivot table field always as Sum but after open new pivot the field always changed.
Pivot.png

Thank in advance for your help.

Kind regards,
Wie

[humdingaling]

the reason and possible solution is outlined in post #2 on this link
http://www.mrexcel.com/forum/excel-q...ted-count.html

essentially if all cells are numeric it will sum
if just one cell is not it will default to count

[wiewie002]

Dear Friend,
Noted and thanks for your help

Kind regards,
Wiie

[FlameRetired]

the reason and possible solution is outlined in post #2 on this link
http://www.mrexcel.com/forum/excel-q...ted-count.html
.........

My anti-virus anti-other stuff blocked this link / site. Surprising. This is a highly regarded site. Never happened to me before. Anyone else having problems?

[MarvinP]

I was able to open the link, no problems.