Insert a slicer in excel 2010 how to#

Afterward, select any cell inside the pivot table > go to the Pivot Table Analyze tab > Filter group > Insert Slicer tool. You can choose multiple fields to serve as.

Insert a slicer in excel 2010 how to#

Support for this functionality has not yet been made available for SAS OLAP data accessed via an Excel 2010 PivotTable.Īs an alternative, if you use the SAS OLAP Analyzer now available in SAS Add-in for Microsoft Office 4. At the very beginning, follow the first 7 steps from the previous method to learn how to insert a pivot table from a table or data range. From the PivotTable Tools Options tab, choose Insert Slicers. Apparently it is 'This tutorial covers a straight forward scenario with an Excel 2010 PivotTable connected to a SQL Server 2008 R2 database using a simple SQL.

When accessing a SAS OLAP cube, attempting to select Insert Slicer generates an error similar to the following, and the slicer is not added to the PivotTable. The reason I ask is because when I try to insert slicers in the Options tab of the pivot table, the 'Insert Slicer' option is grayed out. Go to the Options tab > Sort & Filter group > Insert Slicer tool. When viewing Microsoft OLAP data within a PivotTable in Microsoft Excel 2010, you can select the Insert Slicer PivotTable option to insert a slicer navigation area at the top of the PivotTable. Insert Slicers in Excel 2010 Go to Insert tab > Insert Slicer tool.