Skip to Content
0

Cumulation and Last Value at Bex

Mar 24 at 07:01 PM

41

avatar image

Hi All,

We have an requirement where current output is as follows,

To above output i need to add a column for cumulative quantity w.r.t to Schedule Line

Adding to that , once value is accumulated with respective sales order/Schedule line

i need to show the latest Billing Number corresponding to schedule line some thing Like this.

(Note that the cumulate check box in Query KF will cumulate all 5 Line items, *not w.r.t. to any char.)

current-output.png (13.1 kB)
n-output.png (7.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ashu Yadav Apr 10 at 06:36 PM
1

Thanks Matthias,

Already went through this link, but as i say it will cumulate at every subsequent line item in overall report, but i needed w.r.t to Schedule line.

Anyway, Considering the report performance too , I decided to go with modeling level change and added a keyfigure to be populated with self-loop and a Flag for last value w.r.t to my required Char.

BR

Show 1 Share
10 |10000 characters needed characters left characters exceeded

You could use the version 'Cumulative Value Display' for a characteristic but this comulates every key figure.

Regards,
Matthias

0
Matthias Kadletz
Apr 09 at 12:01 PM
0

Hi Ashu,

to achieve the output of the first screenshot you have to use the function 'Cumulative Value Display' for a characteristic. There is only one disadvantage, the values of all Basis Key Figures of the Query are cumulated regarding this characteristic.

Check the following WIKI Page
Cumulative Value Display

At the moment I see no possibility to show only the last Billing number row (coniditons doesn't work for that scenario).

Regards,
Matthias

Share
10 |10000 characters needed characters left characters exceeded