Database

[{pid:"erwer",qty:3,LevelDetails:{level1:{userId:1,amount:10},level2:{userId:2,amount:20},level3:{userId:3,amount:13},}},{pid:"qwsdfg",qty:1,LevelDetails:{level1:{userId:1,amount:10},level2:{userId:4,amount:20},level3:{userId:3,amount:13},}},]

Query

db.collection.aggregate([{$set:{_levelDetails:{$objectToArray:"$LevelDetails"}}},{$unwind:"$_levelDetails"},{$group:{_id:"$_levelDetails.v.userId","TotalLevel1Amount":{$sum:{$cond:[{"$eq":["$_levelDetails.k","level1"]},"$_levelDetails.v.amount",0]}},"TotalLevel2Amount":{$sum:{$cond:[{"$eq":["$_levelDetails.k","level2"]},"$_levelDetails.v.amount",0]}},"TotalLevel3Amount":{$sum:{$cond:[{"$eq":["$_levelDetails.k","level3"]},"$_levelDetails.v.amount",0]}}}},{$project:{_id:0,userId:"$_id",TotalLevel1Amount:1,TotalLevel2Amount:1,TotalLevel3Amount:1}},{$sort:{userId:1}}])

Result