Column sum

[millicentdark]

Hi experts,

i have created an SQL query where the columns selected are below;

But i can not do same display of sum of a column with my SAP HANA graphical calculation views

how do i achieve this sum option in SAP HANA.

Regards

Justice

[Former Member · Accepted solution]

Hi Justice,

Make column 'Debit' as measure at Semantics layer whose Aggregation function is 'Sum' by default as shown below

When you are creating calculated measure you don't have to specify SUM function explicitly which does aggregation already for you, so adding your measure in calculated column expression gives expected results

To see the query of your view, choose below data preview option where you can see the query generated.

Hope this is helpful.

Best Regards,

Shireesha