I'm new to Access and the Pivot table totals don't make sense. Here's a basic example - I have the following table:

ORGANIZATION DECISION DATE Amount
Org 1 5/1/2005 $15,000.00
Org 2 5/1/2005 $10,000.00
Org 3 7/1/2005 $1,000.00
Org 4 7/1/2005 $9,000.00

In access I setup a pivot table with decision date (years/months) and organization as rows, and Total in the totals area. The resulting PivotTable doesn't SUM the totals for each month and put that in the Totals row. Instead, it just repeats the entries for each month. For example:

Years Months Organization Totals


2005 May Org 1 $15,000
May Org 2 $10,000
TOTAL $15,000
$10,000

What I am expecting to happen is that the TOTAL for May would appear as $25,000, not just repeat the individual Amount entries for May. For example, an Excel PivotTable with the same table would automatically SUM the totals for each month, and also automatically include a grand total SUM of all Amounts.

Can someone explain what I am doing wrong, and how to correct this?

Thanks