Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculated fields-Pivot tables
Hello to all you excel Gods, I have created a pivot table to show the total gross and average gross of sold items. I have included the amount of stock items and on order items. My problem is that my average gross is showing for a total of the sold new,sold used , stock and on order items as my worksheet has a seperate column for sold, stock and on order. Therefore I thought "Calculated fields" would work. I does for one instance but I can't seem to have more than one calculated field show on the pivot table. I wanted to show a field for the total sold new and used stock then another showing the total gross divided by a total of new and used sold. Sorry for the essay. Gross New Sold Used Sold Stock On order 5721.82 7 0 2 0 10569.21 29 3 3 9 Average gross I want to be Gross divided by New sold plus Used sold. Thanks in advance |
#2
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
How to change default page setup for pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Tables, calculated fields | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Excel 2002 -> Problem with calculated fields in Pivottable | Excel Discussion (Misc queries) |