Pivot Tabe- Add a calculate column

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table column summing 0
Creating a Calculated Field in a Pivot Table for same field 3
Average of % in pivot table 1
Use icon sets relatively in a pivot table 1
How to add a percentage column in a Pivot Table 1
Column Heading on each row in pivot table 1
Add AVERAGE column to Pivot Table 0
Creating a pivot table which resembles a SQL 'group by' 2

Top