2 Replies Latest reply on Sep 20, 2012 7:43 AM by Alison Cuan

    Filtering by most recent date, varies by campaign

    Alison Cuan

      Hi all,

       

      In the attached, I have a set of campaigns ("Opportunities") with performance updates made on different dates. Not all campaigns are updated at the same time. I would like to be able to display only the updates with the most recent Campaign Event Last Modified Date. Essentially, I need to be able to calculate and filter by the WINDOW_MAX of Campaign Event Last Modified Date per Opportunity. I've included the current Window_Max calculation I've been playing with, but I can't get it to compute the correct Last Modified Date for each Opportunity, no matter how I set the addressing and partitioning fields.

       

      Thanks in advance for your help!

       

      Alison