Need help with filtering between two table.

[Trahman1971]

Hello, I am trying to find a way to filter data from few columns and between two tables. 

My goal is to calculate total "payload_reporting" that sent to PC01. 

payload_reporting is in table1. 

Here are the filter that I have to take care: 

1. From table 1 

2. From table 2: 

Could anyone help me with this ? Thank you 

[FreemanZ]

hi @Trahman1971 

how are table1 and table2 related?

[Trahman1971]

[Trahman1971]