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!!!!
:)
hi
did u solved u r problem.
please let me know bcz iam also facing same problem.
thanks and regards
anil kumar
Did you try to set the filter to be 'after auto aggregation'?
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])))