How to calculate a cumulative total in HANA
I have a detail table (e.g. GL line item table) which has entries for 'posting date', account number, year, month, posting amount (single key figure) and account type (whether the account is a profit & loss account or a balance sheet account.
The requirement is to create a view which shows balance of month for profit and loss accounts and cumulative balance per month for balance sheet accounts (i.e. total of all line items till end of the month, not just for the month).
Currently I am able to get only balance for the month , but not the cumulative balance.
How can I calculate a cumulative amount column/key figure - either through Analytical view or calculation view?