Forecast the sales figure for the month of December(12th month)

[srishsum2017]

Hi all,

Please suggest the solution for Forecasting the sales figure for the month of December(12th month) with below data

Month	Sales in Rs
1	1000
2	2000
3	2500
4	3500
5	3800
6	4000
12	??

Thanks in advance

[varshavig12]

Hi Sumit,

I haven't used the forecast feature.

Check the below link:

Forecast

Try this in your exp:

=if(Month<>'12',sum([Sales in Rs]),

    linest_m(total aggr(if(sum(Value),sum(Value)),Month),Month)*Month

    +linest_b(total aggr(if(sum(Value),sum(Value)),Month),Month))

[srishsum2017]

Thanks for the replying it is helpful for me