 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2004balance in pivot table
we are importing a pivot table from column c & d How an we configure colun c minus column d DK Pivot tables have column headings (fields). If you go to the pivot table toolbar, select Formulas>Calculated Field... and fill out your formula here it will make a new field alongside the other two columns that can be manipulated as any other field  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > we are importing a pivot table from column c & d How an we configure colun c minus column d As we don't understand please explain: We have a column Of gain & we have a column Of Expense the expense is not on the same row of the gain can be even 10 rows ahead now when e create the pivot table both columns are going to be sum of gain & sum of expense we couldn't find were to put calculated field for subtracting one from the other to have a subtotal from gain > DK > [quoted text clipped - 5 lines] > > we are importing a pivot table from column c & d How an we configure colun > c minus column d DK Sorry, I am not understanding your reply. Can you perhaps send me a small sample of the data. Take out the obvious bits from the email SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > As we don't understand please explain: > We have a column Of gain & we have a column Of Expense the expense is not on the same row of the gain can be even 10 rows ahead now when e create the pivot table both columns are going to be sum of gain & sum of expense we couldn't find were to put calculated field for subtracting one from the other to have a subtotal from gain > > DK > > [quoted text clipped - 5 lines] > > > we are importing a pivot table from column c & d How an we configure colun > > c minus column d |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.