I'm trying to dynamically get information from another row in the same table without using a JOIN. Is this possible using a LOD (ideal) or table calculation? As a super-simple example, I want to know who is an employee's supervisor next year:

The results should look like:

Notice, that EMPL "C" does not have any next year supervisor even though they were employed multiple years.

The sample shown here and attached is just conceptual -- the actual table is much larger including many more rows/columns so any hard coding of years or IDs is not feasible.

Thanks in advance for looking!