Calculate Closing Balance

[RichardLee]

Hi if someone could help me it will be great.

I have a table with

DATE | AMOUNT | CODE |

how can I create a closing Balance for each of the codes ?

DATE	AMOUNT	CODE
30/11/2005	-97.98	2100
30/11/2005	-81.65	7306
30/11/2005	-16.33	2201
30/11/2005	16.33	2201
30/11/2005	81.65	7306
30/11/2005	97.98	2100
01/01/2009	-294.8	2100
01/01/2009	38.45	2201
01/01/2009	256.35	5000
14/01/2009	-543.86	4000
14/01/2009	-81.58	2200
14/01/2009	625.44	1100
16/01/2009	-97.89	4000
16/01/2009	-14.69	2200
16/01/2009	112.58	1100
19/01/2009	-7091.3	4000
19/01/2009	-1371.74	4000
19/01/2009	-1063.7	2200
19/01/2009	-928.77	4000

[deepanshuSh]

Hi  Richard, The above requirement seems to be confounding. Could you showcase the data and what exactly you are looking for like before and after?

[RichardLee]

I've added a block of the data.

DATE	AMOUNT	CODE
30/11/2005	-97.98	2100
30/11/2005	-81.65	7306
30/11/2005	-16.33	2201
30/11/2005	16.33	2201
30/11/2005	81.65	7306
30/11/2005	97.98	2100
01/01/2009	-294.8	2100
01/01/2009	38.45	2201
01/01/2009	256.35	5000
14/01/2009	-543.86	4000
14/01/2009	-81.58	2200
14/01/2009	625.44	1100
16/01/2009	-97.89	4000
16/01/2009	-14.69	2200
16/01/2009	112.58	1100
19/01/2009	-7091.3	4000
19/01/2009	-1371.74	4000
19/01/2009	-1063.7	2200
19/01/2009	-928.77	4000

I just need to know how to calculate the closing balance for each code even if that means I need to put the opening balance that would be even better.

[BrunPierre · Accepted solution]

This is a front-end approach

Sum(Aggr(Sum(AMOUNT),CODE))

[RichardLee]

Thanks for this Peter.