1 Reply Latest reply on Jul 16, 2012 9:35 AM by philmodjunk

    Unique Records Only



      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. 

        • 1. Re: Unique Records Only

          I'm assuming this sort order

          SalesDate (Descending)

          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.