Create Cumulative figure in HANA Graphical Calculation View

This is a document how you can create a cumulative calculation using HANA Graphical Calculation View. It is one of the easy example, but you can extend it to any complex scenario.

I am creating a Simple file like this and our aim is to create the cumulative column as show bellow.

Product	Annual Sales(USD)	Cumulative Sum Sales
1070	3600	3600
1050	336	3969
1020	220	4156
1060	192	4348

Using Multiple Values in Input parameter for filtering in Graphical Calculation View

In the previous blog SAP HANA: Handling Dynamic Select Column List and Multiple values in input parameter have shown on how to select multiple values for filtration using "Replace" function in procedure.

In that document, we went to procedure approach, since the user needs the dynamic output based on input conditions.

But if the output is static column list, you wouldn't want to use procedure, so in this blog will be explaining on how to achieve the same functionality of handling multiple values filter condition on a graphical calculation view using "Projection".

Problem Description:

Giving the flexibility of choosing the values he wishes to see in the report and then pushing the filtration logic to the lowest level possible.