2 Replies Latest reply on Jan 10, 2013 6:49 PM by Kevin Purcell

    First Sales Date by Customer for Specific Product Equals First Purchase Date

    Kevin Purcell

      Hello,

       

      I have a table that has the following data:

       

      Sales Order Number

      Sales Order Date

      Customer

      Item

      Sales

       

      I am trying to get the date of first order by a customer for a specific item form a list?

       

      I am trying to flag a customer where the first purchase date (all items) = first purchase date when a customer bough the item "books"

       

      Any help would be greatly appreciated.

       

      Kevin