Chart-Visual Composer

[Former Member]

Hi,

In Visual Composer, I use the BAPI_SALESORDER_GETLIST.

İ have several salesorder for one material or one month.

i want to show the sum of the salesorders for one material or salesorders for one month in the chart .

how can i do that?

[Former Member · Accepted solution]

Mustafa,

use the 'group by' operator to achieve this, draw a transition line from output port of the bapi to the operator. select material or date or any parameter by which you want to sum the orders and assign 'group1'. assign 'sum' on the 'delv_qty' parameter. this will sum up the 'delv_qty param by material etc.

prachi

[Former Member]

Thank you Prachi,

İf I want to aggregate the net prices for one material for example, how can i do that, and how can i show this with a chart?