Is there a way in GV to Summarize a view and get as a result the most recent record for certain columns?

For example, from the OE Sales history table, I want to be able to do a Summary Filter and get the most recent Unit Price sold by customer, by item.

thanks.

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.

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

Thank you so much Steve, it worked like magic!