If you need to sum specific items in a pivot table field, you can create a calculated item. For example, if your pivot table contains an Order Status field, with four types of status: Shipped Pending Backorder Canceled You could create a calculated item, named Sold, that sums the units sold, for orders with a [...]

After you create a calculated item in a pivot table, you might need to change its formula. For example, in this pivot table there’s a calculated item named Sold, in the Order Status field. The Sold item sums the orders with a status of Shipped, Pending, or Backorder. Change the Calculated Item Formula You can [...]

If you’ve used calculated items and calculated fields in your pivot table, you can automatically create a list of all the formulas. List the Formulas in Excel 2007 Select any cell in the pivot table. On the Ribbon, under the PivotTable Tools tab, click the Options tab. In the Tools group, click Formulas Click  List [...]