Microsoft Office Tutorials and References
In Depth Information
Sorting and Filtering Pivot Table Data
Figure 9-8 shows you the timeline I created for the sample Employee Data list
by selecting its Date Hired field in the Insert Timelines dialog box. As you can
see, Excel created a floating Date Hired timeline with the years and months
demarcated and a bar that indicates the time period selected. By default, the
timeline uses months as its units, but you can change this to years, quarters,
or even days by clicking the MONTHS drop-down button and selecting the
desired time unit.
I then literally use the timeline to select the period for which I want my pivot
table data displayed. In Figure 9-8, I have filtered the sample pivot table so
that it shows the salaries by department and location for only employees
hired in the year 2000. I did this simply by dragging the timeline bar in the
Date Hired timeline graphic so that it begins at Jan, 2000 and extends just up
to and including Dec, 2000. And to filter the pivot table salary data for other
hiring periods, I simply modify the start and stop times of the by dragging
timeline bar in the Date Hired timeline.
Sorting the pivot table
You can instantly reorder the summary values in a pivot table by sorting the
table on one or more of its column or row fields. To re-sort a pivot table, click
the filter button for the column or row field you want to use in the sorting
and then click the Sort A to Z option or the Sort Z to A option at the top of the
field’s drop-down list.