| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In my pivot table I want to subtrack one column from another.
The two columns are totaled and I want the difference. I went to the field
setting and tried to use difference from but that just give me blanks or errors. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In my pivot table I want to subtrack one column from another.
If the columns are different fields, you can create a calculated field
to subtract one from the other. On the pivot table toolbar, choose PivotTableFormulasCalculated Field. Type a name for the field, and create a formula. chanceygardener wrote: The two columns are totaled and I want the difference. I went to the field setting and tried to use difference from but that just give me blanks or errors. Any suggestions? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In my pivot table I want to subtrack one column from another.
Hi! What if the columns are in the same field? I use in/out in one column in
the data base, and need to find the balance remaining. Any suggestion is appreciated! "Debra Dalgleish" wrote: If the columns are different fields, you can create a calculated field to subtract one from the other. On the pivot table toolbar, choose PivotTableFormulasCalculated Field. Type a name for the field, and create a formula. chanceygardener wrote: The two columns are totaled and I want the difference. I went to the field setting and tried to use difference from but that just give me blanks or errors. Any suggestions? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In my pivot table I want to subtrack one column from another.
Instead of a calculated field, you can use a calculated item
Select the field button for the in/out field and choose PivotTableFormulasCalculated Item Name the formula, and create the formula, e.g. =In-Out to calculate the balance Or, in the data, enter the Out items as a negative quantity, and the row total should show the balance. Excel Enthusiastic wrote: Hi! What if the columns are in the same field? I use in/out in one column in the data base, and need to find the balance remaining. Any suggestion is appreciated! "Debra Dalgleish" wrote: If the columns are different fields, you can create a calculated field to subtract one from the other. On the pivot table toolbar, choose PivotTableFormulasCalculated Field. Type a name for the field, and create a formula. chanceygardener wrote: The two columns are totaled and I want the difference. I went to the field setting and tried to use difference from but that just give me blanks or errors. Any suggestions? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - how do I add a column? | Excel Worksheet Functions | |||
| PIVOT TABLE COLUMN | Excel Discussion (Misc queries) | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
| add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
Hybrid Mode
