set analisys - group by field

[andrew001]

Hi

I'd like to obtain from this table:

CONTO_KEY    MOV

1                        100

1                        200

1                        100

2                        200

2                          50

2                          20   

3                          10

this result, where SUM_MOV_GROUP_BY_CONTO_KEY is the sum of MOV by CONTO_KEY:

CONTO_KEY    MOV     SUM_MOV_GROUP_BY_CONTO_KEY

1                        100      400

1                        200      400

1                        100      400

2                        200      270

2                          50      270

2                          20      270

3                          10        10

I've tried with 'set analisys' but I'm not yet very skilled

thanks

[andrew001 · Accepted solution]

I've found:

SUM (TOTAL <CONTO_KEY> MOV)