Pivottables are used to show numeric summaries.

You can count, sum, average, ..., but you can't show the actual text in that
area.



Jim wrote:

How can I drag the source field to the data area instead of getting sum of or
count of the source field? Thanks

--

Dave Peterson