top of page

Calculated Items In Pivot Tables


When you've created a pivot table in Excel, you can easily add two fields together and list the result in new field - one not present in your original data source.

1. When you begin the pivot, add the main field from the pivot table you will review data for and a second field which has entries to be tracked for each of the main field items, to the Row area of the field list. In this example, we want to review the groceries sent to three different cities.

2. Next in the pivot table, select a cell with one of the items you want to run a calculation for, and then go the Analyze menu, go to Fields, Items, & Sets . . . Calculated Item.

3. Give a name to a new field, and then select the field that has the items that you want to add up. In the formula box, simply list the items separated by a plus sign. You should see the field whose items are referenced in the formula in the title bar of the dialog box.

4. Finally, pull down a third field into the values area, and set it so a count of that field is generated. The new field, in this example 'Total_Fruit' will show just the sum of the formula you entered.

Naturally, a calculated item can show the result of any number of formulas.


Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

​

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

​

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page