Pivot Cells Values
 

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 and it doesn't seems to be possible within the pivot table
standard options. Is there a chance for this to be possible with VB?

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.

Pivot Cells Values
 

A pivot table is to summarize numerical data as you show. The only thing I
could think of is to use the pivot table to get counts as you show, then us
another sheet or a different area on the same sheet to link to the row and
column headers produced, then us lookup formulas against those headers and
your source data to pull in the appropriate name.

--
Regards,
Tom Ogilvy


"Cajeto 63" wrote:

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 and it doesn't seems to be possible within the pivot table
standard options. Is there a chance for this to be possible with VB?

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.

Pivot Cells Values
 

Thank you for your answer Tom,

Your answer bring another question, is there a formula to lookup on 2 values
(Column Headers & Row Headers)?

Thanks.


"Tom Ogilvy" wrote:

A pivot table is to summarize numerical data as you show. The only thing I
could think of is to use the pivot table to get counts as you show, then us
another sheet or a different area on the same sheet to link to the row and
column headers produced, then us lookup formulas against those headers and
your source data to pull in the appropriate name.

--
Regards,
Tom Ogilvy


"Cajeto 63" wrote:

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 and it doesn't seems to be possible within the pivot table
standard options. Is there a chance for this to be possible with VB?

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.

Pivot Cells Values
 

It depends on your data, but

vlookup
hlookup
lookup
combinations of:
match
index
offset

--
Regards,
Tom Ogilvy


"Cajeto 63" wrote:

Thank you for your answer Tom,

Your answer bring another question, is there a formula to lookup on 2 values
(Column Headers & Row Headers)?

Thanks.


"Tom Ogilvy" wrote:

A pivot table is to summarize numerical data as you show. The only thing I
could think of is to use the pivot table to get counts as you show, then us
another sheet or a different area on the same sheet to link to the row and
column headers produced, then us lookup formulas against those headers and
your source data to pull in the appropriate name.

--
Regards,
Tom Ogilvy


"Cajeto 63" wrote:

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 and it doesn't seems to be possible within the pivot table
standard options. Is there a chance for this to be possible with VB?

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.

Pivot Cells Values
 

Thank you Tom, I will try this out and see if I can get what I want out of it.

Regards, and thanks again for your help.

"Tom Ogilvy" wrote:

It depends on your data, but

vlookup
hlookup
lookup
combinations of:
match
index
offset

--
Regards,
Tom Ogilvy


"Cajeto 63" wrote:

Thank you for your answer Tom,

Your answer bring another question, is there a formula to lookup on 2 values
(Column Headers & Row Headers)?

Thanks.


"Tom Ogilvy" wrote:

A pivot table is to summarize numerical data as you show. The only thing I
could think of is to use the pivot table to get counts as you show, then us
another sheet or a different area on the same sheet to link to the row and
column headers produced, then us lookup formulas against those headers and
your source data to pull in the appropriate name.

--
Regards,
Tom Ogilvy


"Cajeto 63" wrote:

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 and it doesn't seems to be possible within the pivot table
standard options. Is there a chance for this to be possible with VB?

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.