Results 1 to 3 of 3

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

  1. #1
    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.

  2. #2
    Join Date
    Jul 2011
    Posts
    623

    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

  3. #3
    Join Date
    Aug 2011
    Posts
    566

    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.

Similar Threads

  1. Replies: 2
    Last Post: 16-02-2012, 06:28 PM
  2. How to move the total column in Microsoft Excel Pivot Table
    By (Cowherd) in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 05:55 PM
  3. How to copy a pivot table into a 2 dimensional table ?
    By Udyami in forum Windows Software
    Replies: 4
    Last Post: 27-11-2010, 11:35 PM
  4. To convert a pivot table to a flattened table in MS Excel
    By zeemga in forum Windows Software
    Replies: 3
    Last Post: 27-11-2010, 06:48 AM
  5. Replies: 3
    Last Post: 27-11-2010, 05:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,721,663.39844 seconds with 17 queries