[{"_id":ObjectId("63ceb466db8c0f5500ea0aaa"),"Partner_ID":"662347848","EarningsData":[{"From_Date":ISODate("2022-01-10T18:30:00.000Z"),"Scheme_Name":"CUSTOMERWINBACKJCA01","Net_Amount":256,},{"From_Date":ISODate("2022-02-10T18:30:00.000Z"),"Scheme_Name":"CUSTOMERWINBACKJCA01","Net_Amount":285,}],"createdAt":ISODate("2023-01-23T16:23:02.440Z")}]

db.collection.aggregate([{$match:{"Partner_ID":"662347848"}},{$unwind:"$EarningsData"},{$group:{_id:{Scheme_Name:"$EarningsData.Scheme_Name",Month:{$month:"$EarningsData.From_Date"}},Net_Amount:{$sum:"$EarningsData.Net_Amount"}}},{$project:{_id:0,Net_Amount:1,Scheme_Name:"$_id.Scheme_Name",Month:"$_id.Month"}}])