This content has been marked as final. Show 2 replies
Ran into a challenge trying to match specific column results to identical results in different rows.
Employee Name Manager Name Grade
Bob Alex 2
Fred Bob 1
George Bob 1
I'm using "Manager Name" as a field to sort span of control. Unfortunately, the grade for "Manager Name" is the grade of the employee, not the grade of the manager.
I'm trying to create a calculated field to return "2" whenever Manager Name = "Bob".
Any ideas re: an easy way to do this? \