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:
If the value selected is May-12, then I would like the result to be like this:
If the value selected is Apr-12, then I would like the result to be like this:
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