[{"_id":"63888d85674a07e0d7d2eccc","products":[{"productId":{"_id":"63888c6c674a07e0d7d2e6ee","category":"CEIS","productCategory":"Others"},}],},{"_id":"63888d92674a07e0d7d2ecf5","products":[{"productId":{"_id":"63888c17674a07e0d7d2e68a","category":"CEIS","productCategory":"CEIS Merchandise"},},{"productId":{"_id":"63888c17674a07e0d7d2e68b","category":"ABC","productCategory":"ABC Merchandise"},}],},{"_id":"63888db6674a07e0d7d2ed93","products":[{"productId":{"_id":"63888c8c674a07e0d7d2e725","category":"CAHS","productCategory":"Clinical Equipments"},}],}]

db.collection.aggregate([{$unwind:"$products"},{$group:{_id:"$products.productId.category",total:{$sum:1}}},{$sort:{total:-1}},{$project:{_id:0,category:"$_id",total:1}},{$limit:1}])