M
Martin
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
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