Acumulation rutine grouped by several fields

Tue, 09 Jul 2013 22:01:03 GMT

Hi,

having a table like this:

load * inline [

hotel,year,month,amount,

bpt,2011,ene,1,

bpt,2011,feb,2,

bpt,2011,mar,3,

bpt,2011,abr,4,

bpt,2011,may,5,

bpt,2011,jun,6,

bpt,2011,jul,7,

bpt,2011,ago,8,

bpt,2011,sep,9,

bpt,2011,oct,10,

bpt,2011,nov,11,

bpt,2011,dic,12,

bpt,2012,ene,1,

bpt,2012,feb,2,

bpt,2012,mar,3,

bpt,2012,abr,4,

bpt,2012,may,5,

bpt,2012,jun,6,

bpt,2012,jul,7,

bpt,2012,ago,8,

bpt,2012,sep,9,

bpt,2012,oct,10,

bpt,2012,nov,11,

bpt,2012,dic,12,

bpt,2013,ene,1,

bpt,2013,feb,2,

bpt,2013,mar,3,

bpt,2013,abr,4,

bpt,2013,may,5,

bpt,2013,jun,6,

bpt,2013,jul,7,

bpt,2013,ago,8,

bpt,2013,sep,9,

bpt,2013,oct,10,

bpt,2013,nov,11,

bpt,2013,dic,12,

bco,2011,ene,5,

bco,2011,feb,7,

bco,2011,mar,9,

bco,2011,abr,11,

bco,2011,may,13,

bco,2011,jun,15,

bco,2011,jul,17,

bco,2011,ago,19,

bco,2011,sep,21,

bco,2011,oct,23,

bco,2011,nov,25,

bco,2011,dic,27,

bco,2012,ene,5,

bco,2012,feb,7,

bco,2012,mar,9,

bco,2012,abr,11,

bco,2012,may,13,

bco,2012,jun,15,

bco,2012,jul,17,

bco,2012,ago,19,

bco,2012,sep,21,

bco,2012,oct,23,

bco,2012,nov,25,

bco,2012,dic,27,

bco,2013,ene,5,

bco,2013,feb,7,

bco,2013,mar,9,

bco,2013,abr,11,

bco,2013,may,13,

bco,2013,jun,15,

bco,2013,jul,17,

bco,2013,ago,19,

bco,2013,sep,21,

bco,2013,oct,23,

bco,2013,nov,25,

bco,2013,dic,27];

How could I use 'rangesum' or 'for...next' or 'group by' or whatever or acombination of them to join an accumulation field by 'hotel' and 'year' like this?:

hotel	year	month	amount	accum by hotel&year
bpt	2011	ene	1	1
bpt	2011	feb	2	3
bpt	2011	mar	3	6
bpt	2011	abr	4	10
bpt	2011	may	5	15
bpt	2011	jun	6	21
bpt	2011	jul	7	28
bpt	2011	ago	8	36
bpt	2011	sep	9	45
bpt	2011	oct	10	55
bpt	2011	nov	11	66
bpt	2011	dic	12	78
bpt	2012	ene	1	1
bpt	2012	feb	2	3
bpt	2012	mar	3	6
bpt	2012	abr	4	10
bpt	2012	may	5	15
bpt	2012	jun	6	21
bpt	2012	jul	7	28
bpt	2012	ago	8	36
bpt	2012	sep	9	45
bpt	2012	oct	10	55
bpt	2012	nov	11	66
bpt	2012	dic	12	78
bpt	2013	ene	1	1
bpt	2013	feb	2	3
bpt	2013	mar	3	6
bpt	2013	abr	4	10
bpt	2013	may	5	15
bpt	2013	jun	6	21
bpt	2013	jul	7	28
bpt	2013	ago	8	36
bpt	2013	sep	9	45
bpt	2013	oct	10	55
bpt	2013	nov	11	66
bpt	2013	dic	12	78
bco	2011	ene	5	5
bco	2011	feb	7	12
bco	2011	mar	9	21
bco	2011	abr	11	32
bco	2011	may	13	45
bco	2011	jun	15	60
bco	2011	jul	17	77
bco	2011	ago	19	96
bco	2011	sep	21	117
bco	2011	oct	23	140
bco	2011	nov	25	165
bco	2011	dic	27	192
bco	2012	ene	5	5
bco	2012	feb	7	12
bco	2012	mar	9	21
bco	2012	abr	11	32
bco	2012	may	13	45
bco	2012	jun	15	60
bco	2012	jul	17	77
bco	2012	ago	19	96
bco	2012	sep	21	117
bco	2012	oct	23	140
bco	2012	nov	25	165
bco	2012	dic	27	192
bco	2013	ene	5	5
bco	2013	feb	7	12
bco	2013	mar	9	21
bco	2013	abr	11	32
bco	2013	may	13	45
bco	2013	jun	15	60
bco	2013	jul	17	77
bco	2013	ago	19	96
bco	2013	sep	21	117
bco	2013	oct	23	140
bco	2013	nov	25	165
bco	2013	dic	27	192

Thanks

topic Acumulation rutine grouped by several fields in QlikView

Acumulation rutine grouped by several fields