I have a list which has all the information stored of everyone in the organisation.
Now, i want to create a view for all the nodes in the hierarchy in the organisation such that the line manager will be able to view his/her reportees status and
this continues till the CEO. For example, in the diagram below:
Now, if a manager sitting in the LOB1 visits the view, he should see the records of Program1, Program2, Program3 but not from the programs of LOB2 or LOB3. People from all the LOBs are entering information, but the view will only display hte relevant details.
If we create a Lookup column and depending on the Assigned To column gets back all the managers inline and fetches into the column so that when we create a view, we can use a filter for that column and equals [me] for displaying relevant information. The problem here is that we have a list for looking up the information. Could you please help me with an idea or a logic for displaying the results.