2 Replies Latest reply: Jul 21, 2014 8:32 AM by Olivier Buchy RSS

    Get expression for latest date

    Olivier Buchy

      ex. Loaded table


      Week, value

      week 1, 2

      week 1, 3

      week 1, 1

      week 2, 1

      week 2, 3

      week 3, 1

      week 3, 2

       

       

      I want to get : sum(value) for most recent week (i.e. "week 3"); I suspect a combination of aggr() and firstsortedvalue() should do the trick, but I can't nail it down.

       

      Thanks for your help.