I'm not sure if this is possible in a search or not, but I'm trying to show last transaction date by vendor with what type of transaction the last one was. So: Column 1 - vendor Column 2 - Last Trxn Date Column 3 - what trxn type the transaction was that has the last trxn date Vendor & Last Trxn Date are easy enough since you can just do a summary search with Max of Trxn Date. Doing Max on the Transaction Type column doesn't necessarily return the value that coincides with the Last Transaction Date though. I think I've tried to get there in the past using PARTITION BY and OVER, etc, but I either can't remember how or it didn't work. Anyone know how to kind of "link" the Last Transaction Date with its trxn type?

Hi - If you use "When ordered by field" and the transaction: date, it should give you the results you want.

That's awesome @Laura and exactly what I needed, thanks! Somehow I've never used that before, but that's a way easier solution than I was expecting.