Hi everyone. I have a search that displays transaction rates for each item in our store, but I only want to display the newest rate instead of every rate. I went about this by displaying the Transaction: Date column with Age in Days descending so that the most recent Rate is displayed first for each item. Does anyone know how to only display 1 row per item so that it only shows the newest rate for each item? Thanks!

You could add a formula to the Transaction: Date result line, for example MIN here

MIN when ordered by your Date column

Sorry, I don't know much about this, does this look right?

I mean use this