Direct & Indirect Reports
 

Hi All - I'm looking to have a simple output file created that will show me how many direct reports and how many indirect reports every person would have in a given data set (including a zero for those that do not have either)...

- I have the below data fields to work with:

Person Name; Person ID; Supervisor Name; Supervisor ID

- I would ideally like two output tabs where one gives a summary:

Person Name; Person ID; Count of Direct Reports; Count of Indirect Reports

And where the second gives the detail:

Supervisor A:
Direct Report A____ Indirect Report D
Direct Report B____ Indirect Report E
Direct Report C____ Indirect Report F

Count for both direct and indirect

__________________________________________________ _________
Supervisor B:
Direct Report H____ Indirect Report K
Direct Report I____ Indirect Report L
Direct Report J____ Indirect Report M

Count for both direct and indirect

__________________________________________________ _________

Any thoughts would be extremely helpful and appreciated