Pivot Tabe- Add a calculate column
 

I have a datasheet that contain an Inventory qty and a Weekly sales qty and a
Week on Hand per Sku + a total. I want to do a Pivot talble and in the Total
to see the correct Week on Hand calculation. How can I do this ? I do not
see where I can put a calculation. I only see Average, which is not good
since average of the below 3 sku is = 2.7 in stead of 1.4.

Inventory Weekly Sales Week On Hand
A 100 100 1.0
B 5 1 5.0
C 100 50 2.0
Total 205 151 1.4

tks

Pivot Tabe- Add a calculate column
 

Excel 2007
Pivot Table with dynamic auxiliary Table.
Macro.
Not easy.
http://www.mediafire.com/file/xkn2znmjjid/02_17_09.xlsm