If you put a text field into the data area of a pivot table, it will
summarize the field to show a count, instead of showing the text.

You can place the text fields in the Row, Column or Page areas, where
their text will show.

pum75 wrote:

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