Unique Records Only
I have a table with the followingt fields: CustomerNumber, SKU, Price, and SalesDate.
I have sorted the data on CustomerNumber + SKU + SalesDate.
I want to create a report or filter that shows a single record for each unique CustomerNumber and SKU, using the Price for the most recent SalesDate.
All Suggestions are appreciated.