Microsoft Office Tutorials and References
In Depth Information
Viewing Which Records Are Filtered: Using the Slicer
Figure 8–39. The current PivotTable. Note that Walters’ record is included, and sorted, too.
NOTE: The Data Source button identifies the current range of data being processed by the
PivotTable, and you can see that Table1 now appears as the source table, thus incorporating
Walters' record.
Now you can enter as many new records as you like into the Salesperson database, and
whenever you click Refresh those new records will appear in the PivotTable.
NOTE: If your PivotTable shows Sum of Order Amount instead of the Average Amount as
shown in Figure 8–39, it doesn’t matter. Adding and refreshing PivotTable data works no matter
what mathematical operation you’ve selected.
Viewing Which Records Are Filtered: Using the Slicer
Recall that when we filtered multiple items, I noted that filtering more than two
salespersons at the same time doesn’t let you know exactly who’s been filtered (see
Figure 8–40).
Figure 8–40 . Anyone’s guess: Which salespersons have been filtered?
As mentioned, Microsoft recognized this problem, and introduced the Slicer feature in
Excel 2010 as a way to solve it. The Slicer is a kind of free-floating filter that enables you
to see exactly which records have been selected.
Search JabSto ::

Custom Search