How to sum two columns in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
mts
Paul
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grand Total for Rows not Working in a Pivot Table 1
Referencing a pivot tables Grand Totals Column 1
Pivot Table Formula Problem 1
Pivot table problem 4
Pivot table help 2
How do I replace/select new fields in pivot table using a macro? 1
Pivot Table? 1
Derived Columns in Pivot Table 1

Back
Top