0

Filter most recent month for table with multiple entries

I have a table pulling a Salesforce report. In the table, the first column refers to a specific record (which I'll call the key). Periodically, a new record related to that key will show up on the report. The second column has a date associated with the report for that disaster. What I'm trying to do is have each record (key) only show up once based on the latest date in that second column. See screenshot for example. I'm trying to only have that July row show up. Any help would be greatly appreciated!

 

2 comments

  • 0
    Avatar
    Rahul Bura

    Hey Jonathan,

    Hope all is well! Are your dates coming in as new rows always? If so, you can Group your Keys and set your aggregation of your dates column to LAST. Does that work? 

  • 0
    Avatar
    Jonathan Garro

    Thanks Rahul - that does work. I've used GroupBy before but forgot you could use LAST as the final argument in the formula. Thanks!

Please sign in to leave a comment.