Im Trying to achieve a hierarchal view permission on a Sharepoint custom list. A manager / employee relationship, where a manager in the top hierarchy can see all the employees/managers lists items in the Sharepoint. However a manager/employee below cannot see the lists items of the manager/employee above him.
Here is an image to illustrate what i am trying to achieve.
So M1 should be able to see all the list items in this Sharepoint list. and on the other side for example M5 will only be able to see M4 & M6.
I have done some search only for something dynamic but it was very basic by using the [Me] and [Today] which does not work for this case.