Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
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