Select value of max date

[kbryndum]

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 Id	Year_Month2	Year_Month	RunningSum
SW1293	201203	Mar-12	149
SW1293	201204	Apr-12	147
SW1293	201205	May-12	201
SW1294	201203	Mar-12	27
SW1294	201204	Apr-12	75
SW1294	201205	May-12	45
SW1297	201203	Mar-12	12
SW1325	201202	Feb-12	250
SW1325	201203	Mar-12	102
SW1326	201202	Feb-12	100
SW1326	201203	Mar-12	25

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

Global   Item Id	Year_Month2	Year_Month	Value
SW1293	201205	May-12	201
SW1294	201205	May-12	45
SW1297	201203	Mar-12	12
SW1325	201203	Mar-12	102
SW1326	201203	Mar-12	25

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

Global   Item Id	Year_Month2	Year_Month	Value
SW1293	201204	Apr-12	147
SW1294	201204	Apr-12	75
SW1297	201203	Mar-12	12
SW1325	201203	Mar-12	102
SW1326	201203	Mar-12	25

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