One slicer to control two pivot tables that have different source datas and a common key

[Tester1000]

Hi all,

I have two data tables:

1) Production data with column headers: Key, Facility, Line, Time, Output

2) Costs data with column headers: Key, Site, Cost Center, Time, Cost

The tables have a common key named obviously as Key. The data looks like this:

Key Facility Line Time Output
Alpha A Line 1 1,2015 400
Alpha A Line 2 1,2015 100
Beta B Line 2 1,2015 300
Gamma C_A Line 3 1,2015 500
Gamma C_A Line 1 1,2015 1500
Gamma C_B Line 2 1,2015 2300
Delta D Line 1 1,2015 500
Epsilon E Line 1 1,2015 200
Farao F Line 2 1,2015 100
Gabriel G Line 3 1,2015 600
Gabriel G Line 2 1,2015 900


And like this for Cost data:

Key Site Cost center Time Cost
Alpha Kr Manuf 1,2015 1200
Alpha Kr Maintenance 1,2015 500
Beta Bg Manuf 1,2015 3400
Beta Bg Maintenance 1,2015 900
Gamma Bt Manuf 1,2015 1400
Gamma Bt Maintenance 1,2015 900
Delta Gl Manuf 1,2015 500
Delta Gl Maintenance 1,2015 200
Epsilon La Manuf 1,2015 300
Epsilon La Maintenance 1,2015 200
Farao Mb Manuf 1,2015 4000
Farao Mb Maintenance 1,2015 2000
Gabriel Ti Manuf 1,2015 1000
Gabriel Ti Maintenance 1,2015 800


I would like to have two pivot tables which I can filter with ONE slicer based on the column Key. The first pivot table shows row labels Facility, Line and column labels Time. Value field is Output. The second pivot table shows row labels Site, Cost Center, and column lables Time. Value field is Cost.

How can I do this with Power Pivot? I tried by linking both tables above to a table with unique Keys in PowerPivot and then creating a PivotTable where I would have used the Key from the Keys table... Did not work

Thanks in advance!