Here is how you can filter data in two tables using only one set of filters:
|(click to zoom)
The idea is simple:
- Append both tables keeping track of data origin.
- Apply filters to the united dataset (filtered columns should have the same names in both datasets)
- Split the united dataset back into two tables. When filters for the united dataset change, the derived tables will update automatically.