Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi.
Try this model. Maybe can help you.
Maybe someone create a better way.
Alessandro Furtado
Thanks Furtado.
I need this to be implemented in set analysis . I can't change the script.
Thanks.
Any clues on this ? I need your help
Thanks.
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)