Forecast by Progress

[Reuven12]

Hey all,

I have an issue I don't know how to resault.

I have a sales table that includes data between 01/01/2010 and 31/03/2010 

and I want to create a forecast for the months April to December.

how can I do it? I tried with linest_m but it only gives me one month ahead.

that's my table:

LOAD
CustomerID,
year(OrderDate) as Year,
month (OrderDate) as Month,
OrderDate ,
OrderID,
ProductID,
AMOUNT as Amount,
CANCEL_FLAG
Resident Sales

Thank you.