pivottable: Why do I get Count instead of Sum when numeric data

  • Thread starter Søren Søndergaard
  • Start date
S

Søren Søndergaard

If my source date is numeric I expect to get a Sum for a column. Often I get
Count instead of. How can I change med source data?
 
R

Ron Coderre

I believe that typically happens if the amounts column contains blanks.
If you double-click the field in Layout, you can change the function to SUM.


Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top