Beginning Pivot Tables in Excel 2007

CHAPTER 6Sorting and Filtering in aPivot Table

Instead of viewing a summary of all the pivot table data, you may want to focus on a specific district's data or one technician's results. In this chapter, you'll filter the pivot table to show only the data from one district or for selected service types and to show the work orders for a specific date range. You'll also sort the data in your pivot table to arrange the summarized data from the highest to lowest values and from the lowest tohighest values.

By sorting and filtering the data in a pivot table, you can focus on areas where performance could be improved or pinpoint the activities that are consuming the most resources. With these pivot table tools you can go from the big picture, comparing ...