Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I've found:
SUM (TOTAL <CONTO_KEY> MOV)