This is little bit tricky because, I believe, you are trying to filter different fields with same name.
In this case, you need to duplicate data to allow Tableau to show filter-out-ed data in other table.
I used Union to achieve this.
Need some other prep.
if [Table Name]= "Sheet1" then [Send] else [Recv] end
if [Table Name]= "Sheet1" then "Send" else "Recv" end
Sheet "Send" is for "Send" by using Data source "Sheet1"
Sheet "Recv" is for "Recv" by using Data source "Sheet11"
So respective [Table Name] filter is added on both sheets and filtered accordingly.
Then because user cannot distinguish which is which, I added [Title] on column.
Now you change [CTRL Filter] filter as universal.
And get Dashboard work as expected.
Filter Action help_SM_10.1.twbx 14.7 KB
Perfectly works in my scenario.
Appreciate your step by step explanation too.