I'm trying to SUM 'Qty Ordered' values from one table where the 'Item'
column = the 'Code' value from a different table and the Pending' column
= "Y".I have the following code that works for the first condition:SUM(
SELECT( Order History[Qty Ordered]...