forecasting: three years avarage

[#1]

HI,

I have a requirement where I need to show forecast for the next three years from the last actual data point. For example I have data till 2012. I need to show data for 2013 as average of (2010+2011+2012)/3, then 2014 as (2011+2012+2013)/3 where 2013 was a forecasted value. Similarly for 2015 as (2012+2013+2014)/3

I have data till 2012 only. Can someone please tell me how to generate the forcasted data in chart for this. If I have to do this in load script, I dont have any issue with that either

Thanks in advance for the help

Arif

[#2]

HI ,

      If you consider Sales as field which contains the data for each year then

please try the below code in the Script and play around to make it more feasible one .

Tab:

Load

Year , Sales ,  ( Peek('Sales' , -1) ,  Peek('Sales' , -2 )    ,  Peek('Sales',-3)   )  / 3         as Average

Resident Fact_TableName ;

Regards

Yusuf Ali