derive new fields from Hierarchy data

Sun, 09 Aug 2015 19:02:08 GMT

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

Re: derive new fields from Hierarchy data

Gysbert_Wassenaar — Mon, 10 Aug 2015 07:46:49 GMT

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