1 Reply Latest reply: Feb 26, 2014 9:44 AM by Clever Anjos RSS

    Amount by Min Date and Country

    Christian Wunder

      Hi,

       

      I have the following table:

      CountryDateAmount
      Germany25.10.2013100
      Germany02.10.2013500
      USA04.05.201350
      USA10.05.201380
      Greece08.03.201320
      Greece10.03.201360

       

      Now I only want the Amount from the first date by Month and Country, so that the result is:

      CountryDateAmount
      Germany02.10.2013500
      USA04.05.201350
      Greece08.03.201320

       

      I can't do it in the script with "First" and "group by", because I need all rows of the table for other calculations.

       

      Any ideas?

       

      Thanks

      Chris