Pivot Report/Chart Setting

P

Paul Axelrod

When producing a Pivot report or chart in Excel XP, currency fields
are defaulting to Count rather than Sum, which I got in Excel 97.
Does anyone know how to change this default.
Thanks
 
D

Dave Peterson

I just tried it with a small test. I got Sum.

Are you sure you don't have any text or empty cells in that column? I could get
Count with either of those in my data.
 
Top