I am trying to return values only for the last date occurence. For example, if a rep made a call to a customer last year it will return scenario 1 , however, if we made another contact to the same customer this year, it will return scenario 2. I want to return a scenario only for the max date.
Date, Policy #, Scenario
Please help. Let me know if you have any questions.