[{"id":"1","category":"education","field":"science","items":[{"title":"item 1","value":"10"},{"title":"item 2","value":"102"},{"title":"item 4","value":"12"}]},{"id":"2","category":"education","field":"science","items":[{"title":"item 1","value":"4"},{"title":"item 2","value":"23"},{"title":"item 4","value":"45"}]},{"id":"3","category":"fitness","field":"body","items":[{"title":"item 1","value":"87"},{"title":"item 5","value":"45"},{"title":"item =3","value":"23"}]},{"id":"4","category":"education","field":"culture","items":[{"title":"item 1","value":"187"},{"title":"item 5","value":"145"},{"title":"item 3","value":"123"}]}]

db.collection.aggregate([{$unwind:"$items"},{$group:{_id:{category:"$category",field:"$field",title:"$items.title"},value:{$push:"$items.value"}}},{$group:{_id:{category:"$_id.category",field:"$_id.field"},items:{$push:{title:"$_id.title",value:"$value"}}}},{$project:{_id:0,category:"$_id.category",field:"$_id.field",items:1}}])