Skip to Content
0
Former Member
Feb 10, 2011 at 02:59 PM

Calculating specific sum with BEx Analyzer

67 Views

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