Pivot Table Problems
 

I have a pivot table with columns "ID" and "Name" and and a data field
of "Balance" which pulls from an access database.

If I set up the table so ID is the first, some Names disappear.
However, if I put the Name field first, all Names and IDs populate the
list. Either way, the balances are all there and correct.

How do I fix this so that no matter what way a user organizes the data,
no data disappears?