» Retrieving Data from a PivotTable Report
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
To retrieve data, use the GETPIVOTDATA formula:
In Excel 2002 and Excel 2003, it is much easier to use the GETPIVOTDATA formula. Simply select any cell outside the PivotTable report, press the equals (=) sign and select a cell in the PivotTable report's Data area.
In Excel 97 and Excel 2000, insert the formula by manually typing the data field name and the fields.
To retrieve data when the structure of the PivotTable Report is stable, use either:
The INDEX formula combined with the MATCH formula. The defined Names used in the formulas are:
* PivotTableSheet: The name of the entire sheet.
* ColA: Column A.
Note: The number 2 in the MATCH formula stands for column B, which is column 2 in the sheet.
The SUMIF formula combined with the OFFSET formula.
Note: The number 1 in the OFFSET formula stands for one column from the reference address, which is column A.
Book Store:
Recommended Books:
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Keys to Reading an Annual Report (Barron's Business Keys)
- The Fall of Advertising and the Rise of PR
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
No comments have been submitted.
