How to use BEx summation value in another cell

[rahulkavuri]

I need to construct column K values based on sub total values from column H using BEx query, unfortunately I am unable to figure out a way yet. Any help is much appreciated

[MKreitlein · Accepted solution]

Hello Rahul,

what you need is the SUMCT functionality, like shown here:

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

I guess you might want to hide the result line in your newly created column... don't know for sure if this works... you need to test it.

Hope it helps... at least you can google for more examples with this term: SUMCT

BR, Martin

[rahulkavuri · Accepted solution]

Thank you Martin. I tried using SUMCT but this function is only for display purpose. So I searched a little more in SAP knowledge articles and found that I am supposed to use constant selection on Operation field to use the summation. Here is the article -

https://userapps.support.sap.com/sap/support/knowledge/en/1951436