Pivot table data incorrect
 

I have created a very simple pivot table from an Excel 2000 list. There are
no blank rows and I haven't changed any of the default settings. I am only
trying to sum a value. Does anyone know why some of my rows of data wouldn't
be calculating correctly? The Row headings show but either have a zero value
or only sum some of the data. Thanks for your help.

Pivot table data incorrect
 

I figured out that a couple of the fields had incorrect data typed. Thank you.

"Alex" wrote:

I have created a very simple pivot table from an Excel 2000 list. There are
no blank rows and I haven't changed any of the default settings. I am only
trying to sum a value. Does anyone know why some of my rows of data wouldn't
be calculating correctly? The Row headings show but either have a zero value
or only sum some of the data. Thanks for your help.