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

    Displaying value for the last occurence



      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



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


      Thank you,