Excel Slicers – 2 Pivot Tables Based on Different Data Sources

[Ambiguooous]

I tried to do it hear but only one table is changing while the other table is not !! can anyone look at this and help me

 

[Ambiguooous]

I could not attach the excel sheet

 

[sandy666]

Use OneDrive, GoogleDrive or any similar to share your file and post link to this file here

 

[Ambiguooous]

https://1drv.ms/x/s!AhWxMVZ1r6O2amxcYjrkypmKOyg

 

[sandy666]

create slicer from the second PivotTable (PivotTable34) then connect PTs in Slicer ReportConnection

 

[Ambiguooous]

create slicer from the second PivotTable (PivotTable34) then connect PTs in Slicer ReportConnection

Thanks a ton

 

[sandy666]

You are welcome