CHAPTER 12Printing and Extracting Datafrom a Pivot Table

In this chapter, you'll explore different ways to extract and print the data in a pivot table. These techniques can help you drill into the data and solve problems, create an attractively printed document, and pull key pieces of data from a large pivot table.

  • First, you'll use the Show Details feature to extract the data that's summarized in a cell in the Values area. This may help you when troubleshooting or trying to understand the data behind the numbers.
  • Next, you'll use the Show Report Filter Pages feature to create a copy of the pivot table on a separate sheet for each of the items in a selected report filter. This feature can provide a quick way to produce personalized copies of ...

Get Beginning Pivot Tables in Excel 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.