Power Pivot simple one - what am I missing?

[DrDebit]

I have two tables, each with two columns:
Table 1: Employee ID Number and Salary
[TABLE="width: 157"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]ID Number
[/TD]
[TD]Salary[/TD]
[/TR]
[TR]
[TD] 41[/TD]
[TD="align: right"]36000[/TD]
[/TR]
[TR]
[TD] 64[/TD]
[TD="align: right"]96000[/TD]
[/TR]
[TR]
[TD] 153[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD] 228[/TD]
[TD="align: right"]4000[/TD]
[/TR]
[TR]
[TD] 252[/TD]
[TD="align: right"]72000[/TD]
[/TR]
[TR]
[TD] 283[/TD]
[TD="align: right"]76000[/TD]
[/TR]
[TR]
[TD] 327[/TD]
[TD="align: right"]4000[/TD]
[/TR]
[TR]
[TD] 342[/TD]
[TD="align: right"]14000[/TD]
[/TR]
[TR]
[TD] 411[/TD]
[TD="align: right"]30000[/TD]
[/TR]
[TR]
[TD] 415[/TD]
[TD="align: right"]59000[/TD]
[/TR]
[TR]
[TD] 459[/TD]
[TD="align: right"]31000[/TD]
[/TR]
[TR]
[TD] 479[/TD]
[TD="align: right"]12000[/TD]
[/TR]
[TR]
[TD] 499[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD] 531[/TD]
[TD="align: right"]65000[/TD]
[/TR]
[TR]
[TD] 552[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD] 570[/TD]
[TD="align: right"]20000[/TD]
[/TR]
[TR]
[TD] 665[/TD]
[TD="align: right"]20000[/TD]
[/TR]
[TR]
[TD] 676[/TD]
[TD="align: right"]42000[/TD]
[/TR]
[TR]
[TD] 728[/TD]
[TD="align: right"]76000[/TD]
[/TR]
[TR]
[TD] 752[/TD]
[TD="align: right"]40000[/TD]
[/TR]
[TR]
[TD] 790[/TD]
[TD="align: right"]76000[/TD]
[/TR]
[TR]
[TD] 830[/TD]
[TD="align: right"]11000[/TD]
[/TR]
[TR]
[TD] 872[/TD]
[TD="align: right"]74000[/TD]
[/TR]
[TR]
[TD] 885[/TD]
[TD="align: right"]7000[/TD]
[/TR]
[TR]
[TD] 917[/TD]
[TD="align: right"]22000[/TD]
[/TR]
[TR]
[TD] 992[/TD]
[TD="align: right"]50000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1018000
[/TD]
[/TR]
</tbody>[/TABLE]
Table 2: Employee ID Number and Department
[TABLE="width: 381"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]iD Number[/TD]
[TD]Department[/TD]
[/TR]
[TR]
[TD] 992[/TD]
[TD]ADMISSIONS[/TD]
[/TR]
[TR]
[TD] 790[/TD]
[TD]SOE BIOENGINEERING[/TD]
[/TR]
[TR]
[TD] 415[/TD]
[TD]DIVISIONAL DEAN OF PHYSICAL SCIENCE[/TD]
[/TR]
[TR]
[TD] 228[/TD]
[TD]RSLVT RES HALLS FOOD PREPARATION[/TD]
[/TR]
[TR]
[TD] 570[/TD]
[TD]T-MRSHLL II APTS-FOOD PREP[/TD]
[/TR]
[TR]
[TD] 499[/TD]
[TD]ACE ADMINISTRATION & RELATIONS[/TD]
[/TR]
</tbody>[/TABLE]


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?

[TABLE="width: 364"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Department[/TD]
[TD]Sum of Salary[/TD]
[/TR]
[TR]
[TD]ACE ADMINISTRATION & RELATIONS[/TD]
[TD="align: right"]1018000[/TD]
[/TR]
[TR]
[TD]ADMISSIONS[/TD]
[TD="align: right"]1018000[/TD]
[/TR]
[TR]
[TD]DIVISIONAL DEAN OF PHYSICAL SCIENCE[/TD]
[TD="align: right"]1018000[/TD]
[/TR]
[TR]
[TD]RSLVT RES HALLS FOOD PREPARATION[/TD]
[TD="align: right"]1018000[/TD]
[/TR]
[TR]
[TD]SOE BIOENGINEERING[/TD]
[TD="align: right"]1018000[/TD]
[/TR]
[TR]
[TD]T-MRSHLL II APTS-FOOD PREP[/TD]
[TD="align: right"]1018000[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]1018000[/TD]
[/TR]
</tbody>[/TABLE]

Thank you!