I have two tables, each with two columns:
Table 1: Employee ID Number and Salary
<colgroup><col><col></colgroup><tbody>
</tbody>Table 2: Employee ID Number and Department
<colgroup><col><col></colgroup><tbody>
</tbody>
I put them both into power pivot and create a relationship between the employee id numbers.
When I then make a pivot table from them (Department and Salary), I get all the wrong answers. What am I missing?
<colgroup><col><col></colgroup><tbody>
</tbody>
Thank you!
Table 1: Employee ID Number and Salary
| ID Number | Salary |
| 41 | 36000 |
| 64 | 96000 |
| 153 | 40000 |
| 228 | 4000 |
| 252 | 72000 |
| 283 | 76000 |
| 327 | 4000 |
| 342 | 14000 |
| 411 | 30000 |
| 415 | 59000 |
| 459 | 31000 |
| 479 | 12000 |
| 499 | 40000 |
| 531 | 65000 |
| 552 | 1000 |
| 570 | 20000 |
| 665 | 20000 |
| 676 | 42000 |
| 728 | 76000 |
| 752 | 40000 |
| 790 | 76000 |
| 830 | 11000 |
| 872 | 74000 |
| 885 | 7000 |
| 917 | 22000 |
| 992 | 50000 |
| 1018000 |
<colgroup><col><col></colgroup><tbody>
</tbody>
| iD Number | Department |
| 992 | ADMISSIONS |
| 790 | SOE BIOENGINEERING |
| 415 | DIVISIONAL DEAN OF PHYSICAL SCIENCE |
| 228 | RSLVT RES HALLS FOOD PREPARATION |
| 570 | T-MRSHLL II APTS-FOOD PREP |
| 499 | ACE ADMINISTRATION & RELATIONS |
<colgroup><col><col></colgroup><tbody>
</tbody>
I put them both into power pivot and create a relationship between the employee id numbers.
When I then make a pivot table from them (Department and Salary), I get all the wrong answers. What am I missing?
| Department | Sum of Salary |
| ACE ADMINISTRATION & RELATIONS | 1018000 |
| ADMISSIONS | 1018000 |
| DIVISIONAL DEAN OF PHYSICAL SCIENCE | 1018000 |
| RSLVT RES HALLS FOOD PREPARATION | 1018000 |
| SOE BIOENGINEERING | 1018000 |
| T-MRSHLL II APTS-FOOD PREP | 1018000 |
| Grand Total | 1018000 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Thank you!
