Rolling and Forecasting

[Srinivas]

Hi frds,

Here I want rolling months and Forecasting data based on IDs. I'm attaching my excel as well. 

1.Here first tab i have rolling months like -1,-2,-3 like till -12. based on this we have to develop the rolling months data when i select ID that data should be showed previous 12 months sales data.

2.Second tab i have forecasting data have month wise.  when i select any ID then data should be showed next 12 months data.

Thanks & Regards

Munna

[amit_saini]

Munna,

This attachment may help you.

Thanks,
AS

[Srinivas]

Hi Saini,

Forecasting is it ok we have month filed so we can achieved,

But in first tab Previous tab in that we don't have any date fields here we can do based on Previous months(Here months have  -1,-2,-3...so on -12) in this case

My Expression is : Sum({<[Demand Time Series]>=-1 >} Adjusted_Demand_Qty) but it is wrong.

How we can do..?

[Srinivas]

Hi Friends,

Please help on this especially i am facing forecasting issue.