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.