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