Hi, I hope you can help.
This is what I need to do. I have a list of 1,300 employees each attached to a supervisor. I know to get the count of employees for each supervisor, but now I need to know if the supervisor has a direct report(s) how many employees report to that person(s). Is this something I can easily create?
Supervisor A
Employee I
Employee II
Employee III (Supervisor B)
Employee IV
Employee V
I need to have the results in two separate columns, ie: Supervisor A = 3 direct reports, Supervisor Direct Reports Reports = 2 (may be more than 2 columns depending on how deep in the organization)
Does this make sense?
Please let me know of any questions and as always I APPRECIATE you and this forum.
Regards,
Bookmarks