[{"section":"","category":"Food & Drink","sub_category":"Main Dish","product_code":"ST","title":"Steak","description":"Served with sauted vegetables","tags":[],"warranty":"None","product_variants":[{"variant_code":"ST1","variant_title":"Rib Eye","images":[],"status":"Active","variant_details":[{"size":"6oz","local_price":800,"local_discount":"0","foreign_price":0,"foreign_discount":"0","inventory":[{"branch_id":{},"quantity":94}]},{"size":"10oz","local_price":1000,"local_discount":"0","foreign_price":0,"foreign_discount":"0","inventory":[{"branch_id":{},"quantity":147}]},{"size":"12oz","local_price":1200,"local_discount":"0","foreign_price":0,"foreign_discount":"0","inventory":[{"branch_id":{},"quantity":199}]}]},{"variant_code":"ST1","variant_title":"Rib Eye","images":[],"status":"Active","variant_details":[{"size":"6oz","local_price":800,"local_discount":"0","foreign_price":0,"foreign_discount":"0","inventory":[{"branch_id":{},"quantity":94}]},{"size":"10oz","local_price":1000,"local_discount":"0","foreign_price":0,"foreign_discount":"0","inventory":[{"branch_id":{},"quantity":147}]},{"size":"12oz","local_price":1200,"local_discount":"0","foreign_price":0,"foreign_discount":"0","inventory":[{"branch_id":{},"quantity":199}]}]}],},{"section":"","category":"Food & Drink","sub_category":"Main Dish","product_code":"ST","title":"Steak","description":"Served with sauted vegetables","tags":[],"warranty":"None","product_variants":[{"variant_code":"ST1","variant_title":"Rib Eye","images":[],"status":"Active","variant_details":[{"size":"6oz","local_price":800,"local_discount":"0","foreign_price":0,"foreign_discount":"0","inventory":[{"branch_id":{},"quantity":94}]},{"size":"10oz","local_price":1000,"local_discount":"0","foreign_price":0,"foreign_discount":"0","inventory":[{"branch_id":{},"quantity":147}]},{"size":"12oz","local_price":1200,"local_discount":"0","foreign_price":0,"foreign_discount":"0","inventory":[{"branch_id":{},"quantity":199}]}]}],}]

db.collection.aggregate({"$project":{"array":"$product_variants.variant_details.inventory.quantity"}},{"$unwind":"$array"},{"$unwind":"$array"},{"$unwind":"$array"},{"$group":{"_id":null,"size":{"$sum":"$array"}}})