Sales monthly simulation

[#1]

Hi all,

I am buiding a simulation chart where i have the sales by month(dimension) and i want to estimate the sales for the coming month.

i.e:

Available sales for Jan till Oct

Estimation sales for Nov and Dec

i have a yearly target to achieve and i have created the estimation formula.

The issue is: how can i display Nov and Dec in the chart knowing that data is only available for the first 10 months.

Apreciate your help.

Thanks