software

I have 2 sheets of data with 3 common columns [A,B,C] (based on which 2
pivots were created) which had lots of redundant values in each column for
each sheet.
The 1st pivot has sum of values of column D for items under columns A/B/C
i.e..........A-gt;B-gt;C-gt;(sum of D)
The 2nd pivot has A-gt;B-gt;C-gt;Candidate Name-gt;(Joining date as calculated field)

The solution needed is-
Only for items in pivot2 matching A 'and' B 'and' C of pivot1, retrieve
Candidate Name........(which can be multiple for a given A and B and C of
pivot1)

Creating 2 pivots seemed to be a temporary solution for the problem,
however, I need this is one report/table in this format:-
For A-and-B-and-C [in pivot1], get Candidate name(s) [matching A-and-B-and-C
in pivot1 from pivot2]
Is there any pivottable function that I can use?
I hope I have kept the problem description suffice and clear, considering
that I am a starter for pivottables.
Thank you for the help.

Look in Function help at =GETPIVOTDATA.

Regards
Phil Smith

quot;Minervaquot; wrote:

gt; I have 2 sheets of data with 3 common columns [A,B,C] (based on which 2
gt; pivots were created) which had lots of redundant values in each column for
gt; each sheet.
gt; The 1st pivot has sum of values of column D for items under columns A/B/C
gt; i.e..........A-gt;B-gt;C-gt;(sum of D)
gt; The 2nd pivot has A-gt;B-gt;C-gt;Candidate Name-gt;(Joining date as calculated field)
gt;
gt; The solution needed is-
gt; Only for items in pivot2 matching A 'and' B 'and' C of pivot1, retrieve
gt; Candidate Name........(which can be multiple for a given A and B and C of
gt; pivot1)
gt;
gt; Creating 2 pivots seemed to be a temporary solution for the problem,
gt; however, I need this is one report/table in this format:-
gt; For A-and-B-and-C [in pivot1], get Candidate name(s) [matching A-and-B-and-C
gt; in pivot1 from pivot2]
gt; Is there any pivottable function that I can use?
gt; I hope I have kept the problem description suffice and clear, considering
gt; that I am a starter for pivottables.
gt; Thank you for the help.