» 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:
- Marketing Management
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Business Plans For Dummies®
No comments have been submitted.
