Pivot Table not showing subtotals

[Guest]

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]

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.