macro to change multiple slicer values

问题:

I am at a loss after some searching. I have two pivot tables driven from two different data source/caches. source 1 is a table with departments' total charged amounts, source 2 has the same departments with the total denied dollar amounts. I am pulling the data from both of these into pivot tables so that I can manipulate the department (among other things) to calculate percentages.

My original thought was to set a "Department" slicer for each table, and have a macro assigned to one of the slicers to change the second one so that both pivot tables filter the department. I was also thinking of possibly using one slicer, and assigning it a macro to simply filter the department on the second pivot.

both of these tables will be hidden with the exception of one of the slicers and will have the calculated data from each table pulled to the top of the sheet for easy viewing.

both sheets/data sources are derived from separate reports with completely different data & headers.

thanks in advance for any help.

回答1:

I finally came across something useful on contextures

It works exactly how I want it to, I simply linked the slicer connected to 4 other pivot tables with a separate cache than my "main" slicer/table and hid the linked slicer. When I select and option from the main slicer, it updates the hidden slicer thus filtering all the other pivot tables.