O'Reilly logo

Excel Pivot Tables Recipe Book: A Problem-Solution Approach by Debra Dalgleish

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required