Sales & Geo hierarchy

[QlikAngel]

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