Return to FileMaker.com
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.
I'm assuming this sort order
Create a list view layout and remove the body layout part.
Replace it with a sub summary layout part "when sorted by SKU".
Put your three fields in this layout part and you should get one row for each unique Customer-SKU combination, but showing the largest (most recent) sales date.
Retrieving data ...