Hi,
I have attached sample data of Hierarchy
In output need while selecting a date .. sales hierarchy should reflect upto that date.. & city mapping also look accordingly.
selection will be date
table column require:
Reportee name , employee name (EMP), city
Member sheet cease date is termination date of employee
Memrelation sheet cease date is termination date of employee relation to manager
Unitrelation sheet cease date is termination date of city/geography