I'm looking for a way to track employee movements. I have a transaction table to that includes Employee Number, Cost Center and Month values. Is there a way that I can look up the Cost Center that was assigned to an employee from a previous month? I know there is a PREVIOUS function that can pull numeric values, but wasn't sure if there was something similar that can pull the list member for a certain period.
Thanks