» Retrieving Data from a PivotTable Report
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
The GETPIVOTDATA formula allows the retrieval of data from a PivotTable report while its structure is being changed.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:
- Special Edition Using Microsoft Access 2002
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Microsoft Outlook 2002 for Dummies
- The Total Money Makeover. : A Proven Plan for Financial Fitness
No comments have been submitted.
