[{"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([{"$unwind":"$product_variants"},{"$unwind":"$product_variants.variant_details"},{"$unwind":"$product_variants.variant_details.inventory"},{"$set":{"total_local_price":{"$multiply":["$product_variants.variant_details.inventory.quantity","$product_variants.variant_details.local_price"]}}},{$group:{_id:null,total_qty:{$sum:"$total_local_price"}}}])