Conslidate based upon two unique ids

Hey guys, 

So, I am working with some purchasing data and need help fixing/conslidating the data. For each Purchase Order (PO) we will have multiple lines for different items, and each line can have multiple deliveries. The issue is that the data shows the qty ordered as the total for each line and does not split it up even when there are multiple deliveries.

Is there a way in PBI to consolidate the qty ordered based upon the PO # and the Line #? 

See example: 

Delivery             PO                 Line                 Product                 Vendor                 Qty Ordered              Qty Received

1233                  1111              1                     X                           ABC                      1000                           500

1233                  1111              1                     X                           ABC                      1000                           500

1244                  1111              2                     Y                           ABC                      300                             100

1244                  1111              2                     Y                           ABC                      300                             150

1255                  1111              2                     Y                           ABC                      300                             50

Right now, a sum will show that we ordered 2000 of product X and 900 of product Y when I need PO 1111 Line 1 (product X) to show a total qty ordered of 1000 and Line 2 (Product Y) to show a total qty ordered of 300. Note that there are multiple POs for different companies/items and thus averaging will not work when there are mulitple POs/deliveries that have the same item.

I would like to be able to show the total qty ordered from each company compared to the quantity received. 

Thanks!