Filtering using the same table as base

Hello To all

I'm trying to show in a report info that should be filter by two values that are in the same table, if I do it as it is I get zero results (which is correct).

How can I do this?

My table A is:

wid  value

1       2

2       8

3       3

4       5

5       1

Table B

id wid value type
1   1     2        1

2   1     4        2

3   2     5        1

4   3     3        1

5   3     9        2

6   4     8        1

They are linked by wid

and I what to have the possibility to shoe the values filter by type.

if I use type 1 in one filter and type 2 on the other

it should dispay the wid 1 and values 2 and 4.

Should I make auxiliary tables for each type but dinamic ones?

Thanks