CHAPTER 2Sorting and FilteringPivot Table Data
As you analyze data in a pivot table, you may want to rearrange the items in the Row Labels and Column Labels areas, or sort the summarized values, to focus on products that are selling the best, or districts that are doing poorly. Sorting the labels or the values lets you move the most important information to the top. You can also filter the labels or the values to limit the data summarized in the pivot table.
Unless otherwise noted, the problems in this chapter are based on data in the sample file named FoodSales.xlsx.
2.1. Sorting a Pivot Field: Sorting Row Labels
Problem
Three fields are in the Row Labels area of your pivot table: District, City, and Category, as shown in Figure 2-1. District, ...
Get Excel 2007 PivotTables Recipes: A Problem-Solution Approach 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.
