Filter controls cannot be created for offline OLAP PivotTables. To create a filter control for this PivotTable, you must ...

Filter controls cannot be created for offline OLAP PivotTables. To create a filter control for this PivotTable, you must change the PivotTable data source to be on-line OLAP. On the Analyze tab, in the Tools group, in the OLAP tools menu, click Offline OLAP and select On-line OLAP in the Offline OLAP Settings dialog box.