Connecting pivot tables and Slicers

Excel 2010 introduced new functionality into Excel in the form of Slicer controls. A Slicer can be thought of as an Excel data control that connects to multidimensional data as a client tool, which has built-in functionality for interacting with pivot tables. Since the tabular model is presented to Excel as a multidimensional model (it is essentially a server model stored in Excel and accessed through Excel's client tools), the pivot table and Slicer can connect to the tabular model.

In fact, the PowerPivot Field List is a special field list for interacting with a pivot table based on the tabular model that includes two window groups for horizontal and vertical Slicers, as shown in the following screenshot (the horizontal or vertical position only refers to the Slicers position in relation to the location of the pivot table). This is only available in Excel 2010.

While the Slicer can be attached to a pivot table through the PivotTable Field list, the Slicer...