Chapter 35: Analyzing Data with Pivot Tables
731
Filtering Pivot Tables with Slicers
A Slicer is an interactive control that makes it easy to filter data in a pivot table. Figure 35.20 shows
a pivot table with three Slicers. Each Slicer represents a particular field. In this case, the pivot table
is displaying data for New customers, opened by tellers at the Westside branch.The Excel Pivot Table feature creates a summary table from a list. But what if you want to perform the
opposite operation? Often, you may have a two-way summary table, and it would be convenient if the
data were in the form of a list.In the figure here, range A1:E13 contains a summary table with 48 data points. Notice that this sum-
mary table is similar to a pivot table. Column G:I shows part of a 48-row table that was derived from the
summary table. In other words, every value in the original summary table gets converted to a row,
which also contains the region name and month. This type of table is useful because it can be sorted
and manipulated in other ways. And, you can create a pivot table from this transformed table.The companion CD-ROM contains a workbook, reverse pivot.xlsm, which has a macro that will
convert any two-way summary table into a three-column normalized table.A Reverse Pivot Table