Vickie:

I'm not sure I'm understanding your requirements correctly.

You need a View that shows for each customer the last time they purchased each item ever sold to that customer and what they paid for it?

Cust A
Item A Jan 18 $5.00
Item B Apr 25 $4.00
Item C Jan 18 $3.25

Where the date is the last time that item was sold to Cust A and $ is the Unit price on that sale?

This isn't really a summary, more like a super filter.

I believe we have done something like this before but off the top of my head I don't recall how we go it to work. Something I can look at when I'm back in the office on Tuesday.