Database
[{"_id":ObjectId("61e8c7bbd0597207179faa89"),"clientId":"DEMO","matchStatus":{"summary":{"totalRows":"10","fullMatch":"5","noMatch":"1","partialMatch":"4"},"income":{"totalRows":"10","fullMatch":"1","noMatch":"0","partialMatch":"1"}},"date":"18-01-2022"},{"_id":ObjectId("61e8c7bbd0597207179faa90"),"clientId":"DEMO-1","sizes":["1","2"],"matchStatus":{"summary":{"totalRows":"10","fullMatch":"5","noMatch":"1","partialMatch":"4"},"income":{"totalRows":"10","fullMatch":"1","noMatch":"0","partialMatch":"1"},"slip":{"totalRows":"10","fullMatch":"1","noMatch":"0","partialMatch":"1"},},"date":"18-01-2022"}]
Query
db.collection.aggregate([{"$match":{"_id":{"$in":[ObjectId("61e8c7bbd0597207179faa89"),ObjectId("61e8c7bbd0597207179faa90")]}}},{"$set":{"matchStatus":{$objectToArray:"$matchStatus"}}},{"$unwind":"$matchStatus"},{"$replaceRoot":{"newRoot":"$matchStatus"}},{"$set":{"v":{$objectToArray:"$v"}}},{"$unwind":"$v"},{"$group":{"_id":{k1:"$k",k2:"$v.k"},"sum":{"$sum":{"$toInt":"$v.v"}}}},{"$group":{"_id":"$_id.k1","field":{"$push":{k:"$$ROOT._id.k2",v:"$$ROOT.sum"}}}},{"$project":{"v":{$arrayToObject:"$field"}}},{"$group":{"_id":null,"field":{"$push":{k:"$$ROOT._id",v:"$$ROOT.v"}}}},{"$replaceRoot":{"newRoot":{$arrayToObject:"$field"}}}])