[{"orderNo":1000,"orderItem":0,"orderType":"CUST","company":{"name":"CUSTOMER GMBH","uic":"DE300000XX"},"custPO":{"grandTotal_eur":146,"products":[{"product":{"code":"PROD-1000","title":"Product title 1000","toBuy":true,"supplier":{"code":"PROD-SUPP-1000","title":"Product supplier title 1000","company":{"name":"SUPPLIER ONE GMBH","uic":"DE1000XXXX"},"price":6}},"qty":5,"price":10,"valueTotal":50},{"product":{"code":"PROD-2000","title":"Product title 2000","toBuy":true,"supplier":{"code":"PROD-SUPP-2000","title":"Product supplier title 2000","company":{"name":"SUPPLIER TWO GMBH","uic":"DE2000XXXX"},"price":15}},"qty":2,"price":20,"valueTotal":40},{"product":{"code":"PROD-1010","title":"Product title 1010","toBuy":true,"supplier":{"code":"PROD-SUPP-1010","title":"Product supplier title 1010","company":{"name":"SUPPLIER ONE GMBH","uic":"DE1000XXXX"},"price":2}},"qty":2,"price":3,"valueTotal":6},{"product":{"code":"TRANS","title":"Transport fees"},"qty":1,"price":50,"valueTotal":50}]}},{"orderNo":1000,"orderItem":1,"orderType":"SUPP","company":{"name":"SUPPLIER ONE GMBH","uic":"DE1000XXXX"},"suppPO":{"grandTotal_eur":34,"products":[{"product":{"code":"PROD-SUPP-1000","title":"Product supplier title 1000"},"qty":5,"price":6,"valueTotal":30},{"product":{"code":"PROD-SUPP-1010","title":"Product supplier title 1010"},"qty":2,"price":2,"valueTotal":4}]}}]

db.collection.aggregate([{$unwind:"$custPO.products"},{$match:{"custPO.products.product.toBuy":true}},{$group:{_id:{orderNo:"$orderNo",supplierName:"$custPO.products.product.supplier.company.name"},company:{$first:"$company"},"supplierTotal":{$sum:"$custPO.products.valueTotal"}}},{$group:{_id:"$_id.orderNo",company:{$first:"$company"},"totals":{$push:{"supplierName":"$_id.supplierName","supplierTotal":"$supplierTotal"}}}}])