[{"group_id":"ABC","category":"test","account":"abc1","sku":"grre,qrvf","revenue":100,},{"group_id":"ABC2","category":"test","account":"abc","sku":"grre,qrvf","revenue":100,},{"group_id":"ABC3","category":"test2","account":"abc2","sku":"qwe","revenue":100,},{"group_id":"ABC","category":"test2","account":"abc","sku":"qwe","revenue":100,},{"group_id":"ABC2","category":"test3","account":"abc2","sku":"asd,fgh","revenue":100,},{"group_id":"ABC","category":"test3","account":"abc","sku":"asd,fgh","revenue":100,},{"group_id":"ABC3","category":"test","account":"abc2","sku":"grre,qrvf","revenue":100,}]

db.collection.aggregate([{$facet:{group:[{$group:{_id:"$group_id",revenue:{$sum:"$revenue"}}},{$project:{_id:0,group:"$_id",revenue:1}}],categories:[{$group:{_id:"$category",revenue:{$sum:"$revenue"}}},{$project:{_id:0,category:"$_id",revenue:1}}],accounts:[{$group:{_id:"$account",revenue:{$sum:"$revenue"}}},{$project:{_id:0,account:"$_id",revenue:1}}],skus:[{$group:{_id:"$sku",revenue:{$sum:"$revenue"}}},{$group:{_id:null,aggregates:{$push:{sku:"$_id",revenue:"$revenue"}}}},{$project:{_id:0,single:{$filter:{input:"$aggregates",cond:{$eq:[{$indexOfBytes:["$$this.sku",","]},-1]}}},multi:{$filter:{input:"$aggregates",cond:{$ne:[{$indexOfBytes:["$$this.sku",","]},-1]}}},},}],}}])