This content has been marked as final. Show 2 replies
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!