Forum Discussion
Sums in a Pivot Table
I added a value to a pivot table of BALANCE. It automatically set the Summarize Value to COUNT. I switched it to SUM, but the values all come out to zero. I double checked my source sheet and the val...
SEdwards Do you really check if your "currency number" is actual number and not text which looks like numbers? Is there any blank cell in your value column in raw data?
A rule for pivot tables is: If ANY cell in your value column (field) contains text, blanks, or errors (#N/A, #REF!, #VALUE!, #NAME?), the pivot table calculation type will default to COUNT for that value field.