2 Replies Latest reply: Nov 25, 2010 9:33 AM by alexaxo

# Pivot table, offset, days stock coverage

HI there,

does anybody know how to solve the problem below?

Desired Result 1: is the consumption of actual stock of code A. At a given time 24/11 you start with a stock of 1000 and I would like to know how the stock will evolve by fulfilling orders.

Desired Result 2: I would like to know how many days of coverage I have before getting out of stock.

 A B C D E F G H I 2 id_code_dwlog dt_date_order 24/11/2010 25/11/2010 26/11/2010 29/11/2010 30/11/2010 01/12/2010 02/12/2010 3 CODE A STOCK 1.000 1.000 1.000 1.000 1.000 1.000 1.000 4 CODE A ORDERS 200 250 200 250 200 200 200 5 CODE A STOCK-ORDERS 800 600 690 810 810 630 600 6 CODE A DESIRED RESULT 1 800 550 350 100 -100 -300 -500 7 EXCEL FORMULA =D3-D4 =D6-E4 =E6-F4 =F6-G4 =G6-H4 =H6-I4 ETC... ETC…. DESIRED RESULT 2 4 3 2 1

Thank in advance for any ideas or help.

Axo

• ###### Pivot table, offset, days stock coverage

Would be easier if you could upload an excel with the date & the desired results