PLEASE HELP ME WITH RUNNING TOTAL!!!!

[giovanni.lucarelli]

Hello to everybody!!!

Please can somebody help me? I'm really desperate... :-[

this is my problem: I hope to be the clearest as possible... if you need some other informations don't exitate to write...

I have this report (it's a list):

Dim1   Dim2   YTD   Measure   Run-Total
A   XXXX   2008-Jan        12   62       
A   XXXX   2008-Feb        13   75       
A   XXXX   2008-Mar        2   77       
B   YYYY   2008-Jan        2   42       
B   YYYY   2008-Feb        3   45       
B   YYYY   2008-Mar       11   56       
C   ZZZZ   2008-Jan       12   22       
C   ZZZZ   2008-Feb        1   23       
C   ZZZZ   2008-Mar        7   30       

In report-prompt I choose a Month and then I create a Query item (Selected-Period) and then theYTD query Item as periodsToDate(...[YEAR], Selected-Period) and it works fine; then I create this calculated-measure Run-Total: running-total(Measure for [Dim1],[Dim2]) that you can see in the report.... but it ignores the filter YTD!!!! as you can see the Run-Total starts for XXX with 62, YYYY with 42 and ZZZZ with 22...then it's OK... but 50 (i.e. 62-12, or 42-2=40 ...) is the value of the measure before 2008-Jan...
sorry for my English...

however, I want to say: the running total doesn't care about YTD then it's in the report and start from the total before 2008-Jan....

Can somebody help me?????  I WANNA THIS:

Dim1   Dim2   YTD   Measure   Run-Total
A   XXXX   2008-Jan        12   12
A   XXXX   2008-Feb        13   25
A   XXXX   2008-Mar        2   27
B   YYYY   2008-Jan        2   2
B   YYYY   2008-Feb        3   5
B   YYYY   2008-Mar       11   16
C   ZZZZ   2008-Jan       12   12
C   ZZZZ   2008-Feb        1   13
C   ZZZZ   2008-Mar        7   20

thanks for everybody!!!!
:)

[anilkumar]

hi

did u solved u  r problem.

please let me know bcz iam also facing same problem.

thanks and regards
anil kumar

[netanel]

Did you try to set the filter to be 'after auto aggregation'?

[CognosPaul]

I've had problems with running-total against olap. Try something like this:

total([Measure] within set periodsToDate ([Cube].[Dates].[Years].[All],currentMember ([Cube].[Dates].[Years])))