Moving Sales

[#1]

I've a requirement to display moving sales for monthwise where the sales should between current month and 12 month from current month .

that is value for 201112 = sum of 201001 to 201112 ,

201201 = sum of 201002 to 201201....

sales for month

201001	10
201002	11
201003	12
201004	13
201005	14
201006	15
201007	16
201008	17
201009	18
201010	19
201011	20
201012	21
201201	22
201202	23
201203	24
201204	25
201205	26
201206	27

Requirement:

201111	165
201112	186
201201	198
201202	210
201203	222
201204	234
201205	246
201206	258

Please help me on this.

Thanks

[#2]

Hi.

Try this model. Maybe can help you.

Maybe someone create a better way.

Alessandro Furtado

[#3]

Thanks Furtado.

I need this to be implemented in set analysis . I can't change the script.

Thanks.

[#4]

Any clues on this ? I need your help

Thanks.

[shree909]

Hi   Try this..

for the actual Month

sum(if(Period=Dt_Period, Qtd))--> set analysis sum({<period={'Dt_Period'}>}qtd)

Last 12 monts...sum(if(Period>= Dt_Period2 and Period<= Dt_Period, Qtd))

set analyis   sum({<period={'>=Dt_Period2, <=Dt_Period,'} >}qtd)