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 [...]