Anyone know how I can only show the most recent change to show for an item and not its history? This is a search for all items that have had their MSRP price changed. I'm grabbing the Date, Old Value, and New Value fields from the System Notes and this is an Item SS. These are all Grouped and I wouldn't want to export to Excel to remove duplicates. You can see for example item AM1010-215-L is showing 3 times but I only want to see the most recent change and that's it.

Can you use a Max Function on the Results for the Date, or even possibly on the Criteria

I've tried both maxium system notes Dates on the Criteria Summary and on the results and it doesn't do it because of the old value and new value amounts being different and grouped

Have you tried Maximum: system notes New Value When Ordered By: system notes Date ? The [When Ordered By] part of a Results column changes it so the maximum is about the When Ordered By column, but the result value is the field selected for the result Column