Skip to Content

Cumulation and Last Value at Bex

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 10 at 06:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 09 at 12:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded