Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BEx - Adding a cumulated column

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

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question