db={"product":[{"_id":"61012014f7416b0a41db7055","name":"MIE","retailPrice":20000,"description":"PRODUK BARU",}],"productInTransaction":[{"_id":"6106a3b1f1bbd62640c7b404","transactionDate":{"$date":"2021-08-01T00:00:00.000Z"},"productsInTransactions":[{"_id":"6106a3cff1bbd62640c7b405","productId":"61012014f7416b0a41db7055","qty":100,"price":5000,"description":"asdn"},{"_id":"6106a3cff1bbd62640c7b406","productId":"61012014f7416b0a41db7055","qty":50,"price":5000,"description":"asdn"}]},{"_id":"6106a3b1f1bbd62640c7b4007","transactionDate":{"$date":"2021-08-01T00:00:00.000Z"},"productsInTransactions":[{"_id":"6106a3cff1bbd62640c7b407","productId":"61012014f7416b0a41db7055","qty":25,"price":5000,"description":"asdn"},]}]}

db.productInTransaction.aggregate([{"$match":{"transactionDate":{"$gte":ISODate("2021-07-01T00:00:00.000Z")}}},{"$unwind":"$productsInTransactions"},{"$group":{"_id":"$productsInTransactions.productId","qty":{"$sum":"$productsInTransactions.qty"}}},{"$lookup":{"from":"product","localField":"_id","foreignField":"_id","as":"data"}},{"$project":{"name":{"$arrayElemAt":["$data.name",0]},"retailPrice":{"$arrayElemAt":["$data.retailPrice",0]},"qtyInTransaction":"$qty"}}])