| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot table calculation for difference between 2 columns &sources
In article ,
says... I need to create a difference calculation in my pivot table to calculate the difference between two data sources for the same time period. Any help is greatly appreciated! Data Source Sum of Jan Item Desc Jan 06 Jan 07 Difference Test 1 ABC 9,553 1,000 -8,553 Once you have created the PivotTable, select it. Then, from the PivotTable commandbar select PivotTable Formulas Calculated Field... In the dialog box, name the calculated field and enter the appropriate formula. You can select an existing field simply by double-clicking it. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a Pivot Table to repeat the values in the columns? | Excel Discussion (Misc queries) | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| How do I get more columns in a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
