You have to compute the aggregate yourself, something like
LOOP AT t INTO l GROUP BY l-key INTO g. APPEND VALUE #( key = g val = REDUCE #( INIT s = 0 FOR i IN GROUP g NEXT s = s + i-val ) ). ENDLOOP.
or
sum_table = VALUE #( FOR GROUPS g OF l IN t GROUP BY l-key LET total = REDUCE #( INIT s TYPE i FOR i IN GROUP g NEXT s = s + i ) IN key = g val = total ).
JNN
Add comment