BEx - Adding a cumulated column

[Former Member]

Hi all,

I need to design a report like below, in line I have what is drilled down like material, plant, ....

-

---

WEEK 1--

---

|

---

WEEK 2

---

|

---

WEEK 2--

---

|....

-

---

Delivered | Total delivered | Delivered | Total delivered | Delivered | Total delivered |...

Material 1 |---100-|

---

100

---

|--50--|

---

150

---

|200--|---350--

---

|...

Material 2 |---200-|

---

200

---

|--50--|

---

250

---

|---0---|---350--

---

|...

I saw many subjects about that kind of problem but in that specific case I cannot use the SUMCT, SUMGT and/or SUMRT in a formula because the calculation is done according to the line and not the columns like I need.

I tried in ratio properties the "cumulated" option. Even if it looks fine it doesn't work since I need to do calculations for other ratios with the "Total delivered" column.

If you have any idea, you're welcome ;o)

Many thanks,

Corentin.

[Former Member]

I did my cumulated values directly in the cube.

[Former Member]

are your "week" columns fix (or just a drill across like I suspect)?

[Former Member]

You suspect well, drill across.

[Former Member]

then it'll be very hard... could you make a structure on those weeks? or is that out of the question?

[Former Member]

In fact I have 5 ratios per week. I think I could create 5x52 restricted key figures; but that would an ugly job ;o)

I believe I'll have to create this ratio in the cube and find the proper way to update this new KF.

Many thanks.