Database
[{"Request":"first","TotalRequests":12,"Organization":"A","TotalRequestsByOrganization":3,"user":"John Smith","TotalRequestsByUserInOrganization":1},{"Request":"first","TotalRequests":12,"Organization":"A","TotalRequestsByOrganization":3,"user":"John Galt","TotalRequestsByUserInOrganization":2},{"Request":"first","TotalRequests":12,"Organization":"B","TotalRequestsByOrganization":7,"user":"Chris Evans","TotalRequestsByUserInOrganization":4},{"Request":"first","TotalRequests":12,"Organization":"B","TotalRequestsByOrganization":7,"user":"Charlie","TotalRequestsByUserInOrganization":3},{"Request":"second","TotalRequests":3,"Organization":"B","TotalRequestsByOrganization":3,"user":"James Anthony","TotalRequestsByUserInOrganization":3}]
Query
db.collection.aggregate([{$group:{_id:{Request:"$Request",TotalRequests:"$TotalRequests",Organization:"$Organization",TotalRequestsByOrganization:"$TotalRequestsByOrganization"},users:{"$push":{user:"$user",TotalRequestsByUserInOrganization:"$TotalRequestsByUserInOrganization"}}}},{$group:{_id:{Request:"$_id.Request",TotalRequests:"$_id.TotalRequests"},Organization:{$push:{Orgname:"$_id.Organization",TotalRequestsByOrganization:"$_id.TotalRequestsByOrganization",users:"$users"}}}},{"$project":{_id:0,Request:{name:"$_id.Request",TotalRequests:"$_id.TotalRequests",Organization:"$Organization"}}}])