Cumulation and Last Value at Bex

[ashu33]

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.)

[ashu33]

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

[former_member274922]

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

Regards,
Matthias

[former_member274922]

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