4 Replies Latest reply on Sep 8, 2016 8:35 AM by Cheri Beckman

    Need to show only earliest record based on Account Name

    Cheri Beckman

       

      I want to show the first order only for each Account, not all orders for the account.  I created "First Won Date" as MIN([Close Date]) but that calculates by rows so it is useless. 

       

      I want something like:

      "For this Account Name, give me the earliest Close Date and show only that row of data"

       

      Also, this will be for multiple account names so I can't say IF Account Name = EZ Green Home.

       

      Maybe something like:

      "if this Account Name = Previous Row Account Name, show me MIN([Close Date] "??

       

      When this works, only the second row (with the 8/10/2016 date) will appear on this report.

       

      Thanks for your help.

      Cheri