Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
subtracting two pivot table data fields
Hi, I have a pivot table wherein i have two column labels and two data
fields. Now, i want to display another row which contains the difference of the two data fields corresponding to its respective column label. The two data fields are being displayed as a count of the column values in the data source. Please help me out as to how can i display the subtracted value of the two cells in the cell below them in the pivot table. Regards, Alok |
#2
|
|||
|
|||
Quote:
IF the 2 data items you want subtracting are 2 separate fields then use the calculated fields function. Right click the pivot then choose 'formulas'...'calculated field' 1 Name your field 2 Create the formula. Its helpful to double click on the names in the field list as this inserts the Fieldnames to the formula correctly by including single quotes ' as necessary without which it doesn't work Then choose "Add" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Pivot Table help with data fields | Excel Discussion (Misc queries) | |||
Data Fields in Pivot Table | Excel Discussion (Misc queries) | |||
data as a percetage of row fields in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Macro not inserting all data fields | Excel Discussion (Misc queries) | |||
Manipulating Pivot Table Data Fields | Charts and Charting in Excel |