0 Replies Latest reply: Jun 6, 2012 12:13 PM by Kim Bryndum RSS

    Select value of max date

    Kim Bryndum

      Hi,

      I need some help...

      I have generated a table with two (or more) dimensions and an expression. The one of the dimensions is a time dimension.

      The table looks like this:

      Global   Item IdYear_Month2Year_MonthRunningSum
      SW1293201203Mar-12149
      SW1293201204Apr-12147
      SW1293201205May-12201
      SW1294201203Mar-1227
      SW1294201204Apr-1275
      SW1294201205May-1245
      SW1297201203Mar-1212
      SW1325201202Feb-12250
      SW1325201203Mar-12102
      SW1326201202Feb-12100
      SW1326201203Mar-1225

       

      If the value selected is May-12, then I would like the result to be like this:

      Global   Item IdYear_Month2Year_MonthValue
      SW1293201205May-12201
      SW1294201205May-1245
      SW1297201203Mar-1212
      SW1325201203Mar-12102
      SW1326201203Mar-1225

       

      If the value selected is Apr-12, then I would like the result to be like this:

      Global   Item IdYear_Month2Year_MonthValue
      SW1293201204Apr-12147
      SW1294201204Apr-1275
      SW1297201203Mar-1212
      SW1325201203Mar-12102
      SW1326201203Mar-1225

       

      I have tried to work with Set Modifiers with implicit field value definitions, like this (there could be non-associated time values):


      Sum({$<Year_Month2 = {$(=Max( {$<Year_Month2 = P({1} Year_Month2)>} Year_Month2 ) )}>}
      RunningSum)

       

      But it doesn't work, as it only selects lines where Year_Month2 is equal the max possible time value.

      Can anyone help? Any help is much appreciated!

      Thanks

      Kim