In the simple example below, when doing a pivot table, one of the A's and B's
are missing and the subtotals and grand total is missing.

Item Amount
A $1.00
A $1.00
A $1.00
B $2.00
B $2.00
B $2.00

To show the Grand Total, right-click on a cell in the Pivot Table, and
choose Table Options.
Add a check mark to 'Grand totals for columns.

You shouldn't need subtotals, since there would be only one row for A
and one row for B.

Glenn wrote:
In the simple example below, when doing a pivot table, one of the A's and B's
are missing and the subtotals and grand total is missing.

Item Amount
A $1.00
A $1.00
A $1.00
B $2.00
B $2.00
B $2.00



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html