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.