The field should show all the items, unless you've previously hidden some.

I don't understand your example. Can you give a bit more detail on what
you see in your pivot table, and what you expected to see?

Debutante wrote:
Why oh why is it that when I drag the field to the column area it is fine..I
then drag the second one to this area and it gets lost?

Sometimes it does not list all of the entries that field is supposed to
contain. Do I always have to double-click in the fields box to make it
appear.

For example:

Serial #: 777777
Serial #: 999999
Serial #: 77777


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