Pivot Table Subtotals Won't Sum Identical Values

[ExcelEverything]

My pivot table shows the incorrect subtotals when values in the "Amount" column are identical. They are treated like nesting labels?

The other values in that row are also missing when they are identical to the row above... Only different values are displayed.

This is what the pivot table looks like, roughly: [TABLE="width: 500"]
<tbody>[TR]
[TD]Amount[/TD]
[TD]Description[/TD]
[TD]Allocation[/TD]
[TD]Officer[/TD]
[/TR]
[TR]
[TD]$2,500[/TD]
[TD]Grant[/TD]
[TD]Gardening[/TD]
[TD]Mr. B[/TD]
[/TR]
[TR]
[TD]$2,500[/TD]
[TD][Should also be "Grant", but missing[/TD]
[TD][Should also be "Gardening," but missing[/TD]
[TD]Mr. C[/TD]
[/TR]
</tbody>[/TABLE]
$2,500 Sum <--INCORRECT

The correct subtotal is $2,500 instead of $5,000.

Any ideas on how to fix this?

Thanks for your help!

 

[ExcelEverything]

***Oops, I meant "The correct subtotal is $5,000 instead of $2,500"

 

[RoryA]

Is your field definitely set to Sum and not say Max, Min or Average?

 

[ExcelEverything]

Yes it definitely is set to sum. It seems like the values are being treated like labels instead of numbers.

 

[RoryA]

Is your worksheet set to display right to left?

 

[liveinhope]

***Oops, I meant "The correct subtotal is $5,000 instead of $2,500"

can you check your filed list and advise what are your row fields (in order) and what are your value fields