Microsoft Office Tutorials and References
In Depth Information
Modifying Pivot Tables
Figure 9-8:
Sample
pivot table
filtered with
a timeline
created for
the Date
Hired field.
Click the Sort A to Z option when you want the table reordered by sorting the
labels in the selected field alphabetically or, in the case of values, from the
smallest to largest value or, in the case of dates, from the oldest to newest
date. Click the Sort Z to A option when you want the table reordered by
sorting the labels in reverse alphabetical order, values from the highest to
smallest, and dates from the newest to oldest.
Modifying Pivot Tables
Pivot tables are much more dynamic than standard Excel data tables because
they remain so easy to manipulate and modify. Excel makes it just as easy to
change which fields from the original data source display in the table as it
did adding them when the table was created. Additionally, you can instantly
restructure the pivot table by dragging its existing fields to new positions
on the table. Add the ability to select a new summary function using any of
Excel’s basic Statistical functions, and you have yourself the very model of a
flexible data table!
Search JabSto ::




Custom Search