Two relationships in Views I'm wondering if the following construction is posible with Views in Drupal in combination with relationships. I build this in Drupal:

Manager &lt;--(Entity Reference)--&gt; Group &lt;--(Entity Reference)--&gt; User


A manager can control groups with different users, so I have the following setup:


  Manager A &lt;--> Group A &lt;--> User 1 Manager A &lt;--> Group A &lt;-->
  User 3 Manager A &lt;--> Group A &lt;--> User 5 Manager B &lt;-->
  Group B &lt;--> User 2 Manager B &lt;--> Group C &lt;--> User 4
  Manager B &lt;--> Group C &lt;--> User 6 Manager B &lt;--> Group C &lt;-->
  User 7


I'm looking for a way to generate a view with the logged in manager to get all the users of the group the manager is part of. 

So we get this result when I'm logged in with manager B:


  User 2 User 4 User 6 User 7


I tried to create an Contextual filters with an default value of the logged in user. Then 2 relations: one for the

Manager &lt;--(Entity Reference)--&gt; Group


ans an second one for the

Group &lt;--(Entity Reference)--&gt; User


And then I tried to make fields with an relationship. But only I get is no results. Is there a way to get this working?
You will want you view set up so that:


The view is displaying Users.
There is a relationship from User to Group
There is a relationship from Group to Manager
You add the contextual filter that defaults to the currently logged in user. Make this filter use the Group-Manager relationship.