calculation a subtotal as a column

[oguzhankorkut]

Hello All,

I need to calculate total of each material and show this same total for all document numbers of this material. How can i calculate last column of example on a query?

Thanks.

B.R.

[appel_solar_dk]

Hi

SUMCT is a good solution as long as you are in the Bex world but if you use eg Webi it will not work. An alternative is to use constant selection. Create a new KF restricted as "Key Figure" drag in Document number as restriction right click and choose constant selection. Remark that this solution is slower than SUMCT as the data base will have to run a second set of queries.

With kind regards

Kristian

[k_chandra1]

Hello,

Check the SUMCT function in Bex tools.

Reference Link : https://blogs.sap.com/2013/10/04/data-functions-in-bex-query-designer/

Thanks,

Chandra