Hi Vickie

I do this frequently. I create one View that lists all the details, sorted by a composite field called CustItem and a secondary sort DESCENDING on date.

Then I create a second View with the same fields except for Unit Price and an identical composite field. This one is sorted and summarized by CustItem. I create a calculated field that pulls the Unit Price from the first View. Because it is sorted Descending, it will pick the most recent Unit Price.

Steve