Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



What is the way to sum up number of column in Pivot Table

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 09-02-2012
Member
 
Join Date: Oct 2011
Posts: 76
What is the way to sum up number of column in Pivot Table

I do have a pivot table with a few different products that are related to imports and exports. I want to be able also to add the columns of the same product, both import and export. E.G product 1 import is 2000, product 1 export is 2500. How can I manage this in the pivot table.

Reply With Quote
  #2  
Old 09-02-2012
Member
 
Join Date: Jul 2011
Posts: 618
Re: What is the way to sum up number of column in Pivot Table

You could create a calculated item:
  • Select the Product field button
  • On the PivotTable toolbar, choose PivotTable>Formulas>Calculated Item
  • Type a name, e.g. Product1 All
  • In the list of fields, choose Products
  • In the list of items, double-click on Product 1 Import
  • Type a plus sign, then double-click on Product 1 Export
  • Click OK
Reply With Quote
  #3  
Old 09-02-2012
Member
 
Join Date: Aug 2011
Posts: 564
Re: What is the way to sum up number of column in Pivot Table

I can provide you option to add column in Pivot table. Choose the cell in PivotTable report and then choose formula and then click on Calculated Field. Now you can insert a Calculated Field dialog box where you need to provide the name in Name box. Now add any thing in the filed and then insert field box with a hype In the same way you can add up one more column in the same.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What is the way to sum up number of column in Pivot Table"
Thread Thread Starter Forum Replies Last Post
How to add a result column in Pivot table by subtracting two existing columns in Excel Irritator MS Office Support 2 16-02-2012 06:28 PM
How to move the total column in Microsoft Excel Pivot Table (Cowherd) MS Office Support 2 15-02-2012 05:55 PM
How to copy a pivot table into a 2 dimensional table ? Udyami Windows Software 4 27-11-2010 11:35 PM
To convert a pivot table to a flattened table in MS Excel zeemga Windows Software 3 27-11-2010 06:48 AM
Cannot highlight distinct cells in different rows and column in a Pivot table ? Grayson Windows Software 3 27-11-2010 05:25 AM


All times are GMT +5.5. The time now is 03:44 AM.