Excel Pivot Tables Recipe Book: A Problem-Solution Approach

CHAPTER 5Extracting Pivot Table Data

After you create a pivot table, you may want to extract some of the summarized data for use in other parts of the workbook. The GetPivotData worksheet function can be used for retrieving specific data from the pivot table. Another way to extract data is to use the Drill to Details feature, which returns records from the source data for the selected pivot table cell. Finally, the Show Pages feature can be used to create copies of the pivot table on newly inserted worksheets.

Note The GetPivotData examples shown in this chapter are for Excel 2002 and Excel 2003. The arguments required for earlier versions are different. Refer to Excel's Help for examples.

5.1. Using Drill to Details: Extracting Underlying ...