Moving Month average

[shruthibk]

hi i got requirement to find moving month average of most recent month.but it should be done from scripting side.

my requirement is like

metrics	mobnthyear	counter
aa	Jun-15	676
bbb	Jul-15	7676
ttt	Aug-15	998
ytyt	Sep-15	76
aa	Jun-15	76
bbb	Jul-15	65
ttt	Aug-15	65
ytyt	Sep-15	45
bbb	Jun-15	90

expected data model output should be like this for sum

metrics	monthyear	currmonth	prevmonth count	Prevmonthcout2
aaa	jun	752	0	0
bbb	jun	90	0	0
bbb	jul	7741	90	0
ttt	aug	1063	7741	90
ytyt	sep	121	1063	7741

LOAD metrics,

     mobnthyear,

     counter

FROM

[..\dataload\table1.qvd]

(qvd);

NoConcatenate

temp1:

     load

     metrics,

mobnthyear,

     sum(counter) as COUNT

     resident TEM

    group by metrics, mobnthyear;

     //order by mobnthyear desc;

      left join(temp1)

     load

     metrics,

     addmonths(mobnthyear,-1) as mobnthyear ,

     sum(counter) as COUNT1

     resident TEM

    //where COUNT1 is notnull,

    group by metrics, mobnthyear

    ;

//     order by mobnthyear desc;

      left join(temp1)

    load

      metrics,

     addmonths(mobnthyear,-2) as mobnthyear ,

     sum(counter) as COUNT2

     resident TEM

     group by metrics,mobnthyear;

//     order by mobnthyear desc;    

//    

drop table TEM;

i wriiten code like this but i am not finding exam output plz help me to solve this

reggards ,

shruthi