Skip to main content

Hi All,

 

I have a view with “Sales” value in Rows and “Order Date” (aggregated to month level) in Columns. 

 

The last aggregated month Dec2019 has Sales values upto  25th Dec.   I have a Forecast for the next 6 months and I have included the last incomplete month Dec 2019 too.

 

Is it possible to forecast the Sales values for the remaining days of Dec 2019 month and then populate the final forecast for the next 6 months.

 

So the final forecast for the next 6 months starting Jan 2020 should be based on the past complete months including the last month in the actual data (Dec 2019 in this case)

 

Any suggestions will be helpful.

 

Attaching the workbook “Forecast using the complete months”

 

Regards,

Rishi

5 Antworten
  1. 15. Mai 2020, 14:17

    Hello Rishi,

    That is an option in the Forecasting dialog box.  Right-click a point involving the forecast, select Forecast Options.  In the dialog box in the middle, use the option to ignore (exclude) the last n month(s) in the forecast but keeps it in the series.  Best, Don

    Hello Rishi,That is an option in the Forecasting dialog box. Right-click a point involving the forecast, select Forecast Options.

    If this answers your question, please mark as correct so that others may find it useful in the future.