| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tabe Duplicate Grand Total | Excel Discussion (Misc queries) | |||
| PIVOT TABLE Custom Column addition to calculate sum and Percentage | Excel Discussion (Misc queries) | |||
| Calculate Figures in a column if ajacent column has particular da | Charts and Charting in Excel | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| calculate which cells in column A will give me the total of column | Excel Worksheet Functions | |||
Threaded Mode
