How to perform repetitive aggregation over a field in a SAP HANA table?


The logic is pretty simple. You can define a local variable which is used for storing the total sum of all the groups. When you are performing iteration for each group, you can add the sum at the group level to the local variable.

I am not suggesting code as it is very basic and straightforward.

Updated on: 30-Jul-2019

54 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements