Hi,
I don't know how to do what I'm going to explain. So I don't know if I'm in the correct section and I don't know if the subject I entered is correct
So here you go:
I created a link to a database through an ODBC connector (MySQL).
The fields returned are (for instance) : username, date, amount.
It's an online shop.
Let's say the first order was on the 01.01.2008 and the last order on the 11.03.2008.
I have to forecast what would have been the the total amount of orders if the first order would have been placed on the 01.09.2007.
I want it as simple as : divide the total amount of the orders by the number of days between 01.01.2008 and 11.03.2008 and then multiply this number by the number of days between 01.08.2007 and 11.03.2008.
I have all my shops in a pivot table but I can't seem to find a way to get the date of the first order, the date of the last order and add a column with the forecasted values.
See what I mean ?
Thank you for your time
Bookmarks