Hierarchy

[tellmalaika17]

Hello

Need to set Hierarchy for below data :

[Employee, Manager

Simon,

Tom, Simon

Scott, Simon

Betty, Tom

Jean, Tom

Shawn, Scott

Mike, Scott

I am using below Hierarchy syntax, however it doesnt fulfill the requirement. Requirement is to select Simon and it should filter to everyone. Simon is at the top of the hierarchy.

Would appreciate your help in anyway.

Regards,

Malaika

[MarcoWedel]

Didn't find "below Hierarchy syntax" in your post, but maybe this works for you?

Hierarchy (Employee,Manager,EmployeeName)
LOAD *,
     Employee as EmployeeName
Inline [
Employee, Manager
Simon
Tom, Simon
Scott, Simon
Betty, Tom
Jean, Tom
Shawn, Scott
Mike, Scott
];

[tellmalaika17]

Thank you for your response. I am getting the output provided by you but on selecting Simon the hierachy should show both Scott & Tom who are the direct reports for Simon and all other employees present in employeename3. 

Currently once i select,  I only see Scott and Tom.

Have used the same hierarchy syntax as used by you.

Thank you,

Malaika