HR organisation hierarchy

[Inactive User]

I have a HR org data set that is structured like this:

Employee ID	Level	Reports to (Emp ID)
1	CEO
2	Director	1
3	Director	1
4	Manager	2
5	Manager	3
6	Analyst	3
7	Analyst	4
8	Analyst	5

I apologise if this has been answered before I might have missed a link to another thread, but what I want to do is:

If I am a director, I can see everyone who reports to me and their direct reports so I see MY organisation - so I end up with something like the below. Note that I could have different categories of people reporting to me. Director 3 has a Manager and Analyst reporting to them. Ultimately, where-ever I am in the organisation, I want to be able to see who my director is.

Employee ID (dir)	Employee
3	5
3	6
3	8
2	4
2	7

THANK YOU in advance !!

[Luke_C · Accepted solution]

Hi @Inactive User 

Take a look at this weekly challenge, it should get you in the right direction. 

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740