running total

[#1]

Hi Experts,

Has anyone done a running total function in SAP HANA graphical calculation view?

below is my SQL running total but i want to do same in SAP HANA ;

any idea or steps to achieve this?

Regards

Justice

[millicentdark]

Hi deepak,

i can not add filer in a projection.

Regards

Justice

[Former Member]

• Add a projection node, between the final level Semantic and Join. In this Node put the filter condition.

• You need to add the TransID in both of underlying projections(where the base tables exist).

• At the join node, pls dont join any fields( in the snapshot i observe that the debit and credit fields are mapped)

This is what i meant