| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How I can create a Pivot table by selecting two Different Pivot
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How I can create a Pivot table by selecting two Different Pivot
Rajini wrote:
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Selecting Fields in Pivot Table | Excel Discussion (Misc queries) | |||
| How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
| pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Hybrid Mode
