Database

[{"_id":ObjectId("621ccb5ea46a9e41768e0ba8"),"cust_name":"Anuj Kumar","product":[{"prod_name":"Robot","price":15000},{"prod_name":"Keyboard","price":65000}],"order_date":ISODate("2022-02-22T00:00:00Z"),"status":"processed","invoice":{"invoice_no":111,"invoice_date":ISODate("2022-02-22T00:00:00Z")}}]

Query

db.collection.aggregate([{$addFields:{sumOfPrice:{$sum:"$product.price"}}},{$match:{sumOfPrice:{$gt:10000}}}])

Result