I am trying to get the SUM of a group of fields in a view. We hold events and I wanted to create a view that showed How many degree types by total. See below image for quick idea.
So, If there are 20 MD's, I want one row that shows MD's with a total of 20 - versus 20 rows of MD's.
I have look at views aggregation but since it isn't a number I can not see it working. I have also looked at view calc but that just shows a total at the bottom.
I am looking to figure out the best way to handle this. If I have to custom code any help pointing me in the right direction would be greatly appreciated!