[{"_id":{"$oid":"5e6355e71b14ee00175698cb"},"finance":{"expenditure":[{"status":true,"_id":{"$oid":"5e63562d1b14ee00175698df"},"amount":{"$numberInt":"100"},"category":"Sport"},{"status":true,"_id":{"$oid":"5e6356491b14ee00175698e0"},"amount":{"$numberInt":"200"},"category":"Sport"},{"status":true,"_id":{"$oid":"5e63565b1b14ee00175698e1"},"amount":{"$numberInt":"50"},"category":"Outdoor"},{"status":true,"_id":{"$oid":"5e63566d1b14ee00175698e2"},"amount":{"$numberInt":"400"},"category":"Outdoor"}]}}]

db.collection.aggregate([{$unwind:"$finance.expenditure"},{$match:{"finance.expenditure.status":true}},{$sort:{"finance.expenditure.currentdate":-1}},{$group:{_id:"$finance.expenditure.category",amount:{$sum:"$finance.expenditure.amount"}}},{$project:{_id:0,category:"$_id",amount:1}}])