A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

subtracting two pivot table data fields



 
 
Thread Tools Display Modes
  #1  
Old October 22nd, 2009, 07:52 PM posted to microsoft.public.excel.charting
Alok
external usenet poster
 
Posts: 48
Default 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  
Old November 14th, 2009, 02:54 AM posted to microsoft.public.excel.charting
Matrix416[_2_]
external usenet poster
 
Posts: 1
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.