db={items:[{id:38219388214034,status:"inStock",category:"Food",subCategory:"Sweet"},{id:18371917455611,status:"pending",category:"Accessories",subCategory:"Other"},{id:38219388214035,status:"inStock",category:"Food",subCategory:"Sweet"},{id:38219388214032,status:"pending",category:"Food",subCategory:"Sweet"},{id:38219388214031,status:"outOfStock",category:"Food",subCategory:"Sour"},]}

db.items.aggregate([{$group:{_id:{status:"$status",subCategory:"$subCategory"},category:{$first:"$category"},count:{$sum:1}}},{$group:{_id:"$_id.subCategory",category:{$first:"$category"},totalCount:{$sum:"$count"},pending:{$sum:{$cond:[{$eq:["$_id.status","pending"]},"$count",0]}},inStock:{$sum:{$cond:[{$eq:["$_id.status","inStock"]},"$count",0]}},outOfStock:{$sum:{$cond:[{$eq:["$_id.status","outOfStock"]},"$count",0]}}}}])