Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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