2 Replies Latest reply: Dec 11, 2012 12:07 AM by sujeet singh RSS

    Displaying value for the last occurence

      Hello,

       

      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

      12/10/2011, ABC123,1

      12/11/2012,ABC123,2

       

      Please help. Let me know if you have any questions.

       

      Thank you,