Use PivotTable data in a formula outside the PivotTable report

Microsoft Office Excel 2003

Show All Show All

Use PivotTable data in a formula outside the PivotTable report

  1. In the PivotTable report, display the cell that you want to use in your formula.
  2. In the formula cell, type the formula up to the point where you want to include data from the report.
  3. Click the cell in the report. Microsoft Excel adds a GETPIVOTDATA worksheet function to your formula that retrieves the data from the report. This function continues to retrieve the correct data if the report layout changes.
  4. Finish typing your formula and press ENTER.

Note  If you remove any of the fields referenced in the GETPIVOTDATA formula from the report, the formula returns #REF!.