derive new fields from Hierarchy data

[#1]

Hi All,

i have data Like below:

Org_Id, Reportsto,  Employee name

By using Reports to Field need to derive who are  1.IMP_Managers  2.Sub_Managers 3.Workers

1.Reports to 1 are IMP_Managers

example:

Bernard

Frank

Jeffrey

John

Lavina

Michael

OPEN

Peter

Tammy

Tim

2.who are reporting to above 10 IMP_Mnagers are Comes under Sub_Managers

example :Jin Ruan,Nguyen, Hung,Starink, Pascual reporting to John

        Gulati, Rishi ,Knight, Andrew  reporting to Frank

3.Who are working under SUB_Managers are Actual workerrs

please find the sample app and data .

any help would be greately appreciated

Thanks,

Raj

[Gysbert_Wassenaar · Accepted solution]

You can use the Hierarchy function to create a hierarchy table. See attached qvw.