| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make two different columns subtract while using a pivot tab
I am creating a Pivot table and want it to subtract column A from Column B
with in the pivot table. Can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make two different columns subtract while using a pivot tab
Hello,
What you are looking for is called "Calculated Fields". On the PivotTable toolbar, select Formulas|Calculated Field. Name the field and then choose which fields you want to use in the calculation. HTH, JP On Oct 19, 11:54 am, Josh wrote: I am creating a Pivot table and want it to subtract column A from Column B with in the pivot table. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make cells subtract? | Excel Worksheet Functions | |||
| Make array formulay to round a number then subtract 10 from it | New Users to Excel | |||
| pivot tables-drop data in, how to make it show as columns instead | Excel Discussion (Misc queries) | |||
| subtract amounts from different columns? | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Linear Mode
