I am trying to link both of my pivot tables to my slicers, so that they both change when one slicer is edited. I know this is possible as I've seen many solutions online for how to do this, but it does not work for my case, and I am wondering why. See attached spreadsheet, tab "Summary." I've created relations between my two tables by a column called "Identifier," and then I reported the connections for the two tables in the slicer settings. However, when I change the slicer, it only changes the first pivot table.
Bookmarks