Direct & Indirect Reports

[lg123]

Hi All - I'm looking to have a simple output file created that will sho
me how many direct reports and how many indirect reports every perso
would have in a given data set (including a zero for those that do no
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 o
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 appreciate