PowerPivot - Linking 2 PivotTables two one graph and one slicer

[vaibhava09]

Hi


I have attached two pivot tables in the excel file and need help with linking both tables to the same graph and same slicer. How could this be done without having to go to access?


Thanks
Vaibhav

https://www.dropbox.com/s/vg268e5bvtwavje/Powerpivot Query.xlsx

 

[Matt Allington]

The are settings to join slicers to pivots, and pivots to slicers. I don't remember where but click either one and check the menus specific to that object. I am pretty sure the pivot table option is called report connections or something like that.

You could convert the 2 pivots to cube values and then rearrange into a single data set so you can create a chart