How I can create a Pivot table by selecting two Different Pivot

[Rajini]

I am having two diffrent Pivot table One is Employee and other is Salary I
need to take report with the combination of this two Pivot table.

I have tried this with Multiple consolidation range but I am unable to take
data which match Employee name from Employee Pivot table with Employee name
form Salary Pivot table ,Need to match this two fields to get Pivot report.

 

[smartin]

I am having two diffrent Pivot table One is Employee and other is Salary I
need to take report with the combination of this two Pivot table.

I have tried this with Multiple consolidation range but I am unable to take
data which match Employee name from Employee Pivot table with Employee name
form Salary Pivot table ,Need to match this two fields to get Pivot report.

Hi Rajini,

On the face of it, I think you need to combine the data before
attempting a pivot. If the employee names don't match at this step,
that's your problem and you will need to figure out a way to massage the
data so you have matches.