| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table column creation: Mission Impossible ?
I have a table with these field headers Product/Status/USD:-
A/Actual/100 A/Budget/90 A/Variance/10 I have created a Pivot Table with Product as row field (A or B) Status as Column field (Actual, Budget, Variance) USD as Value It looks fine like this but I need to create an additional column called Variance % which is (Variance/Budget x 100%). Please urgently advise how to create this new % column within Pivot Table. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table column independence | Excel Discussion (Misc queries) | |||
| Add a column outside pivot table and... | Excel Discussion (Misc queries) | |||
| Need to Add Column to Data in Pivot Table | Charts and Charting in Excel | |||
| Sort a Column of Dates in Pivot Table | Excel Worksheet Functions | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Threaded Mode
