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.

Name	Alias	Data1	Month
Bill	AAAA	12	June
Ted	BBBB	7	June
Jane	CCCC	8	June
Jill	DDDD	3	June

<tbody>
</tbody>

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.