Database

[{_id:{category:"electronics"},"sku count":1087,"annual cost":216035.68,"annual mrp":287082.21,"margin %":0.24747799593712197},{_id:{category:"food"},"sku count":5,"annual cost":1063.3799999999999,"annual mrp":1764.32,"margin %":0.39728620658383973},{_id:{category:"clothing"},"sku count":363,"annual cost":103426.6981633,"annual mrp":143030.03,"margin %":0.27688822995212964},{_id:{category:"furniture"},"sku count":1,"annual cost":2407.41,"annual mrp":3199,"margin %":0.24744920287589878}]

Query

db.collection.aggregate([{"$facet":{"category":[{$match:{"_id.category":"furniture"}}],total:[{"$group":{"_id":null,"count":{"$sum":"$annual cost"}}}]}},{$unwind:"$category"},{$unwind:"$total"},{$project:{percentage:{"$multiply":[{"$divide":["$category.annual cost","$total.count"]},100]}}}])

Result