Cumulative values on daily buckets result

[Former Member]

Hi BW experts

I would like to create cumulative total on daily buckets results .

Ex

1/1 1/2 1/3

1 2 3

4 7 8

-

---

Total 5 9 11

Cumulative 5 14 25

Cumulative 5 then 59 = 14 then 1425

cumulative on result only . How to achhive this report.

Thanks

Rohan

[Former Member]

Hi,

Go to the "calculate result as" option in Key Figure properties and select "Cumulative" there.

[Former Member]

Hi below is my resuqirement

Num qtyA QTYB QTYC

A 20 30 26

B 40 60 14

C 5 8 3

-

---

Overallresult 65 98 43

Cmulative 65 163 206

I have to display above format in the report

Over result

Cumulative

Cumulative caluclation on over all result on rows

163 = Over all result of QTYB+ cumulative value of QTYA

206 = Over all result of QTYC+ cumulative value of QTYB

Please help to resolve this issue

Appriciate your response

Thanks

Rohan

[former_member181964]

Hi,

Try wth Properties of the Fomula,I hope we can do it. You need to change the Calculation Settings for that Formula.You can have Calculation Ditecion and other options, check one by one.

Thanks

Reddy