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