Drupal Views: Get all of x categorised by y
I haven't learned how this works myself yet, so I can't give you an exact answer, but here's a video tutorial on Using aggregation in Views, which should answer this for you.