Create visual with hierarchy comparing parent vs child

[Anonymous]

I need to create a visual where I can compare the actions of the manager to his staff. I get the data from Active directory but it is not clean enough to create a hierarchy with the PATH() function. What can I do to display on one page the count or sum of actions for the staff and the manager. What complicates it further is that the staff and the managers might not be in the same department. So essentially in the example below I will choose a department and the visual needs to display the users in that department, then show the manager for those group of users and then calculate the actions as per a seperate table. The manager in some cases will not belong to the same department (unlike the example below)

[Anonymous]

@amitchandak - Thank you I already have the User relationship setup. However if I choose a department then the managers name does not always appear as they are in a seperate department. So I need to identify the manager for that user (from the manager column) and then calculate their actions based on the Users relationship between the two tables. Does that make sense? 

[amitchandak]

@Anonymous , In the above case joining Created by with User of staff Hirerachy, should give you the desired output. You can bring in the Manager and User from staff Hirerachy and sum of rest of the columns from Actions table