Sum in load script with two dependent fields

[#1]

Hi,

I'm trying to calculate a sum in a script, currently I'm running out of ideas...

The table looks similar to this:

Main	Sub	Value of Sub
A	A.1	450
A	A.2	550
A	A.3	1000
B	B.1	460
C	C.1	540
C	C.2	300

What I would need now is a sum for Main element A,B,C in a new field of the same table. How can I achieve this?

Thanks&Regards

Jens

[#2]

Could you explain breif

Load

Main,

sum(Main) as Main1,

Sub,

Value

from table

groupby Main,

Sub,

Value;

try like this.......... hope it is helpful

[#3 · Accepted solution]

Hi,

See the attached app :

[#4]

This is working perfectly fine, thanks.