If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
subtracting two pivot table data fields
Alok;893464 Wrote: 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 Alok 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" -- Matrix416 |
Thread Tools | |
Display Modes | |
|
|