Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 318
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   Report Post  
Junior Member
 
Posts: 9
Default

Quote:
Originally Posted by Alok View Post
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"
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Pivot Table help with data fields James Excel Discussion (Misc queries) 3 August 13th 09 05:15 PM
Data Fields in Pivot Table MichaelR Excel Discussion (Misc queries) 0 July 22nd 08 06:36 PM
data as a percetage of row fields in pivot table Eqa Excel Discussion (Misc queries) 0 May 7th 08 06:44 AM
Pivot Table Macro not inserting all data fields [email protected] Excel Discussion (Misc queries) 0 October 27th 06 04:55 AM
Manipulating Pivot Table Data Fields Jay Charts and Charting in Excel 1 November 1st 05 04:48 AM


All times are GMT +1. The time now is 01:52 PM.

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

About Us

"It's about Microsoft Excel"