subtracting two pivot table data fields

  • Thread starter Thread starter Alok
  • Start date Start date
A

Alok

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;893464 said:
Hi, I have a pivot table wherein i have two column labels and two dat

fields. Now, i want to display another row which contains th
difference of
the two data fields corresponding to its respective column label. Th
two
data fields are being displayed as a count of the column values in th
data
source. Please help me out as to how can i display the subtracted valu
of
the two cells in the cell below them in the pivot table.

Regards,
Alok
Click to expand...

Alok
IF the 2 data items you want subtracting are 2 separate fields then us
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 th
field list as this inserts the Fieldnames to the formula correctly b
including single quotes ' as necessary without which it doesn't work
Then choose "Add
 
Back
Top