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