AnsweredAssumed Answered

Unique Records Only

Question asked by dhillock on Jul 14, 2012
Latest reply on Jul 16, 2012 by philmodjunk


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.