Here is my issue:
I have two data sources - 1 being Agent Sales information - 1 being Agent Mileage and Payouts. The data cannot be merged for a variety of reasons. Subsequently I have a Pivot Table created for each data source....with both having a Filter that is Agent's Name, which would have the same dropdown options for both Pivot Tables.
Is there a way to link one filter from a pivot table to mimic the filter from another pivot table - so as to not have to select the same agent twice? My intent is to add more data reports and ultimately more pivot tables, but all with the same Filter and would simply like to choose an agent once and all the filters for every table update to reflect the same selection.
Thanks in advance.
Bookmarks