Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?:
Thanks
