Direct & Indirect Reports

L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top