Microsoft Office Tutorials and References
In Depth Information
Another difference between the types of PivotTables is in the handling of slicers. Slicers are
not a PowerPivot-specific feature—they are a standard feature of Excel. Nevertheless, when
connected to a PowerPivot database, slicers have a slightly easier user interface, both for their
creation (they can be easily created through the Vertical and Horizontal Slicers panes in the
PowerPivot Field List) and for their management (PowerPivot slicers are created in a slicer box
that is easily moveable in the report).
A slicer can be connected to several PivotTables of the same type at the same time, but it
cannot be connected to PivotTables of different types. This means that if you have, for example,
two PivotTables in the same workbook, one of which is based on SSAS and the other one on
PowerPivot, you cannot add a slicer that filters both PivotTables at the same time.
You might be used to looking at PivotTables in their classic, browsable shape, wherein each
row and column label can be expanded and reduced, as you can see in Figure 8-1. You can
find this example in the worksheet CH08-03-Flattened.xlsx on the companion DVD.
FIguRE 8-1 The PivotTable classic layout.
This type of layout is very convenient when browsing data, but it could present some
problems if you want to copy the table information into a new Excel file or any other application
(including PowerPivot itself) because not all the child rows contain full information. For example,
in Figure 8-1, the row for United States does not contain a column for North America because
it should be implied by the previous rows. For this reason, PowerPivot introduces a new type
of PivotTable, called Flattened Pivot Table, which replicates the data in each row, resulting in a
standard tabular format. In Figure 8-2, you can see the same data in a flattened PivotTable.