Ok so here's my take: The start is like yours: notice on my rank, the employees with the same date do not have the same rank, for that I use the option SEQUENTIAL: RANK(joining date, ASCENDING, SEQUENTIAL, TRUE) Now the interesting part: I did not reproduce exactly your dimensions, as I'm not sure what you mean by category and I don't get why you have time. Anyway it should not matter. Not sure how you did your ranking but mine is a simple RANKCUMULATE just for show The trick here is to get the employee and this module DOES NOT KNOW what an employee is, as it doesn't have it as a dimension. In this case, LOOKUP won't work because you have no way to derive the employee from the rank, that relationship does not exist anywhere in a way Anaplan can read it. What I do usually for this kind of logic is the Employee Getter line item, which has the following formula: IF Rank = 'forum: rank on a top list'.Rank calc THEN ITEM(Employees) ELSE BLANK Comparing the ranking in the module vs the ranking in the source module. How does that work ? well I've added the employee dimension to this line item, so it knows about employee and can use the source module. Finally you can simply extract that value in your final Employee line item by referencing it. But don't forget to change the summary of Employee Getter to first non blank so the final line item can just take that summary (because it doesn't know about employees, it can only take the summary If you look inside the Employee Getter subsidiary view, you'll understand what happens: This should work for you. Again, not the same dimensions as you. If you want to add time, you can, or any other dimension, no need to change logic. If you want to rank by/within dimensions, you can use the groups of RANK based on a property of employees (your category) and add it to the comparison of the Employee Getter IF source category = item category AND rank = source rank then item(Employee) else blank
... View more
