Drupal views: How to aggregate CivCRM Relationships?
In the past when I have tried doing this sort of thing I have had to use a Drupal module. 

Maybe try this module:
https://www.drupal.org/project/views_aggregator