Filter tables data on condition

[krish2459]

Hi,

We have two tales  Schedule Lines and Detail.

We need to pull quantity from Schedule line table  where Purchase document and Item from detail table matches with  Purchase document and Item Schedule line table.

Attached is the data sample.

Below is the excel logic in source file for reference.

=SUMIFS('Schedule Lines'!$J$1:$J$1353,'Schedule Lines'!$A$1:$A$1353,PO_Detail!A1058,'Schedule Lines'!$B$1:$B$1353,PO_Detail!B1058)

where J = quantity 

A= purchase document

B= Item.

Thanks,

Thanks,

[krish2459]

Any Suggestions please.

Thanks..

[jensmunnichs]

Hey,

Maybe something like this? (See attached qvw)

Had to separate the two tables in your Excel sheet, hence the Excel attachment.