"Jim May" wrote in message
news:Lst4f.1114$mV4.519@dukeread02...
In PT-101 - I think something was said along the lines of:

The Data Area is designed originally and intended to summarize numeric
data,
and if non-numeric info is used you can only obtain characteristics like
count and ?? hummmm maybe someting else, not sure what..

If I'm wrong maybe someone can correct me..
TIA,

This seems to be a limiting characteristic of the Pivot Table. I was not
able to find a way to make it work. I went back to the original data source
and created a Crosstab query. Unlike anything I was able to find in the
Pivot Table, the Crosstab has a "First" selection, to use in place of Count,
Sum, Avg, etc. The resulting worksheet lacks the "sophistication" of a
Pivot Table, but is a lot better than nothing.

Randy