Show only active/common values in the filter

[Anonymous]

After joining tables, is there a way to use a filter that will only show those common and active field between the two tables?

[Fowmy]

@Anonymous 

Based on the information you have provided, it's hard to understand your requirement. please provide sample data with the expected results.

[Anonymous]

use Project number as filter but will only show values with Cost because in my case, it is showing all the project numbers