Slicer connection to different source

[Siyanna]

Hi All

Im trying to connect a slicer to 2 pivot tables with different sources

Both data tables have been sorted and have duplicates

ie

Table 1

Name Week FTe
A 1 7.2
A 2 7.3
B 1 7.3
B 2 7.3

Table 2

Name Month Fte
A Jan 2.6
A Feb 3.2
A Mar 4.4
B Jan 2.2
B Feb 6.4
B Mar 2.2

etc

I have created 2 pivot tables and have sorted it out the way i want with charts etc

Now all i want is to connect the Name Slicer to be connected to both of those pivot tables but problem is they have duplicates and are from different tables/sources

how can i connect/add this to a data model and connect to my name slicer?

Im sure it maybe something simple but minds not with it

Thank You

 

[Siyanna]

Any advice is appreciated

thank you

 

[Siyanna]

Bump anyone plz