Hi guys,
I got the following scenario which I would like to achieve.
in brackets the atually result is appearing which I don´t need.
Any ideas? Thanks in advance.
first example:
result should be:
dec 2010-------1000
jan 2011----
-
1000
feb 2011----
-
4000
*sum 4000* (6000 actually)
jan 2011----
-
2000
feb 2011----
-
7000
*sum 7000* (9000 actually)
nov 2010-------2000
dec 2010-------4000
jan 2011----
-
6000
feb 2011-1000
*sum 1000* (13000)
*total 12000*
second example:
i tried with "last value" in key figure tab "calculate" and it shows me the result like in the second example.
I tried it also with "last value" and exeption aggregation with characteristic 0calmonth but couldn´t achieve the wished results.
dec 2010-------1000
jan 2011----
-
1000
feb 2011----
-
4000
*sum 4000*
jan 2011----
-
2000
feb 2011----
-
7000
*sum 7000*
nov 2010-------2000
dec 2010-------4000
jan 2011----
-
6000
feb 2011-------1000
*sum 1000*
*total 1000*
Edited by: saplaz on Feb 10, 2011 3:59 PM
Edited by: saplaz on Feb 10, 2011 4:00 PM