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.