Use one slicer to control PivotTable from two PP Tables

[slow1911s]

That description probably didn't help much.

I have a PowerPivot of three tables - a roster, Data1, Data2. I have a connections between the roster and each of the data tables based on an employee alias.

In Data1 and Data 2, the data looks like this.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Alias
[/TD]
[TD]Data1
[/TD]
[TD]Month
[/TD]
[/TR]
[TR]
[TD]Bill
[/TD]
[TD]AAAA
[/TD]
[TD]12
[/TD]
[TD]June
[/TD]
[/TR]
[TR]
[TD]Ted
[/TD]
[TD]BBBB
[/TD]
[TD]7
[/TD]
[TD]June
[/TD]
[/TR]
[TR]
[TD]Jane
[/TD]
[TD]CCCC
[/TD]
[TD]8
[/TD]
[TD]June
[/TD]
[/TR]
[TR]
[TD]Jill
[/TD]
[TD]DDDD
[/TD]
[TD]3
[/TD]
[TD]June
[/TD]
[/TR]
</tbody>[/TABLE]

Data 2 is identical, except the data counts represent something different.

In my PowerPivot, I want to show Name in the row labels and Data1 and Data2 in Values. I want to then use one slicer to control the month. The way it is now, I have to drag month to the slicers area twice, and have two controls that are not connected. I tried to create a relationship between tables Data1 and Data2, but I'm getting an error b/c the values are not unique.

Again, the month column is consistent in Data1 and Data2 - I'd like to use one Month slicer to control my PowerPivot table.

Thanks in advance.

 

[mdrew9]

You need to create unique lists with the name and create relationships from Data 1 and Data 2 up to NameList (date as well). Then use the Name from the Namelist and Date from the date table and pull in the data from each data table.