leader hierarchy - set analysis

[Qlikuser09]

I have Employees table with employee name , leaders name and  leader level relation mentioned as level 1 ,2 , 3 , 4 ,5, 6.

some times the leader be level 6 to a employee and some times , he may be level 3 to a employee, is there a way to have a leader name mention only once under a hierarchy chart. when i create a chart the leader name is duplicated since he is in two location(level 6 and level 3)

[rubenmarin]

Hi, can you post some sample data and the expected result?

[Qlikuser09]

Employee name	leader name	Employee number	Leader employee number	leader relation level
James	John	12345	19876	6
jacob	John	13452	19876	4
francis	John	15647	19876	6
Liam	John	23452	19876	2
Kassie	John	34562	19876	6
klaudia	mary	19087	10675	5
marie	mary	67895	10675	5
ales	mary	34567	10675	3

Here consider John is the CEO and mary next level to john

expected output:

with the leader "John" being the top followed by mary and the employees below her represented in  pivot view

Is there a way i could group by leader name or employee id ??

[rubenmarin]

But what is the real expected output from this data? like this?: