Sorry if it's not clear, I'll try to explain it again:

the data I have is as follow:
N° Nom Date
1 Toto 12/3/2006
2 Albert 3/12/2006
3 Marcel 6/6/2006

And what I want to get is:
N° 3/12/2006 6/6/2006 12/3/2006
1 Toto
2 Albert
3 Christina


The data used above is only for trials purposes. And the objective is an
autorefreshed action plan to know who need to work on what for when. As you
can imagine the list of poeple, dates & numbers can be quite long...

Does it clear the clouds a little?



"CyberTaz" wrote:

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.