[{createdFor:"62429fd5f7db3912fea7a716",itemName:"a",totalQty:100,createAt:"2022-04-05T08:05:41.653+00:00",},{createdFor:"62429fd5f7db3912fea7a716",itemName:"b",totalQty:80,createAt:"2022-04-08T08:05:41.653+00:00",},{createdFor:"62429fd5f7db3912fea7a716",itemName:"b",totalQty:70,createAt:"2022-04-07T08:05:41.653+00:00",},{createdFor:"62223a3f43e080995d5b46bc",itemName:"c",totalQty:110,createAt:"2022-04-09T08:05:41.653+00:00",},{createdFor:"62223a3f43e080995d5b46bc",itemName:"c",totalQty:30,createAt:"2022-04-06T08:05:41.653+00:00",},{createdFor:"62223a3f43e080995d5b46bc",itemName:"c",totalQty:100,createAt:"2022-12-30T08:05:41.653+00:00",/**here this data excludes because out range of date*/},]

db.collection.aggregate([{"$project":{createdFor:1,itemName:1,totalQty:1,createAt:{"$substr":["$createAt",0,10]}}},{"$match":{"$and":[{createAt:{"$gte":"2022-04-05"}},{createAt:{"$lte":"2022-04-09"}}]}},{"$group":{"_id":{for:"$createdFor",name:"$itemName"},"sum":{"$sum":"$totalQty"}}},{"$group":{"_id":"$_id.for","stockInfo":{"$push":{itemName:"$_id.name",totalQty:"$sum"}}}}])