Although it's probably crystal clear to you, it's a bit cloudy on this end
not knowing what fields of data you have in the data range, how you
currently have the PT structured beyond just the Data Area, or what it is
that you're looking to glean from the PT.

Best Guess: Add the field containing the Names to the Drop Column Fields
Here Area (to the right of & in addition to what you're currently using).
Does that come close?
--
HTH |:)
Bob Jones
[MVP] Office:Mac

"Cajeto 63" wrote in message
...
Hello everybody,

I'm trying to find a way to get cells values rather than numbers in the
data
field of a pivot table. I only can get a count of names where I would like
to
get actual names.

In order to make it easier to understand I show bellow what I mean:

What I get from a pivot table is:

Count of Nom Date
N° 3/12/2006 6/6/2006 12/3/2006 Grand Total
1 1 1
2 1 1
3 1 1
Grand Total 1 1 1 3


What I would like to get is:

Count of Nom Date
N° 3/12/2006 6/6/2006 12/3/2006 Grand Total
1 Albert 1
2 Bryan 1
3 Christina 1
Grand Total 1 1 1 3



Does anyone have a trick? It would help a lot.

Thank you.