Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a Pivot Table with Inventory, % of Inventory, Sales, and % of Sales.
To get '% of Inventory' and '% of Sales' I used the Inventory and Sales fields a second time and used the '% of Column' option. My table looks something like this. Category Inventory % of Inventory Sales % of Sales aaaa $30,000 11.91% $31,000 12.31% bbbb $20,000 8.32% $22,000 9.29% cccc $15,000 6.38% $14,000 5.25% etc. What I need to do is subtract '% of Inventory' from '% of Sales'. I realize I can enter this calculation outside of the Pivot Table, but I would love to have it be part of the Pivot Table because I plan to drill-down/expand the Pivot Table and would like it to stay dynamic. Is this possible? Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Totals of calculated field in pivot table give incorrect results | Excel Worksheet Functions | |||
% of calculated field in pivot table | Excel Worksheet Functions | |||
Pivot Table Calculated field item | Excel Discussion (Misc queries) | |||
caluclated field in pivot table? | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |