HANA Calculated coulmn to derive sum of Quantity

[RajeshRamakrishnan]

Hi HANA Gurus,

Greetings.

I have a HANA Calculation View with attributes( VBELN, POSNR, Packing_Station ) Measure LFIMG(Delivered quantity). Now the requirement to create a calculated column Total Delivered Quantity (Sum of based on Packing_station value).

In this example i need to create calculated column =64+11872+4128=16062 (expected Result).

How to achive this calculation . I welcome your valuable inputs.Thanks!

[jan_zwickel]

If it is only for one specific packing station like in your example, then restricted columns with restriction "Dock Packing" might be the way to go.

If you want the sum for all packing stations then it would be a normal aggregation grouped by packing_station. Depending on the required granularity you might want to create a separate aggregation node only for this aggregation.