Microsoft Office Tutorials and References
In Depth Information
Expand the year 2004 by pressing the + sign next to it. The quarters in 2004 are now displayed,
as shown in Figure 10-11.
Expand 2005 and 2006.
Select the Row Labels sort-and-filter drop-down menu.
Open the Date fly-out menu to filter based on quarters.
Select the Filter option.
In the dialog box, select qtr1 and click OK. The values for only the first quarter of each year are
displayed, as shown in Figure 10-12.
Select the Column Labels drop-down menu.
Open the Value Filters fly-out menu and select Top 10.
In the “Top 10 Filter” dialog, change the value to 3 and click OK. The PivotTable is filtered to
show only the Gulf, Northeast, and Southeast regions.