Skip to Content
0
A M
Jul 02, 2018 at 04:25 PM

Show total for movements within the same table in a SAP HANA calculation view

69 Views Last edit Jul 02, 2018 at 06:57 PM 2 rev

Hi,

I have a data set as follows in HANA:

I basically need to show final quantities at the destination in this format:

Unfortunately there is no other indication of a reversal (e.g., B->A) for a forward movement (A->B) other than the existence of the record itself in the same table. All of the records are also in the same table.

The caveat is that it has to be a graphical calculation view. Does anyone have an idea of how this can be achieved?

Any ideas would be very much appreciated.

Thanks.

Attachments

data.jpg (14.3 kB)
output.jpg (11.7 kB)