You cannot filter or sort data in a PivotTable that contains a named set that is above a hierarchy on a SharePoint site that is running Excel Services in SharePoint Server 2010
Consider the following scenario:
- You edit an Excel workbook on a SharePoint site that is running Excel Services in Microsoft Office SharePoint Server 2010.
- The PivotTable in the workbook contains a named set that is above a hierarchy.
In this scenario, you cannot filter or sort the data in the PivotTable.
To work around this problem, move the row labels sothat the named set is under the hierarchy.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 982705 - Last Review: 09/18/2011 23:22:00 - Revision: 2.0
- Microsoft SharePoint Server 2010
- Microsoft Excel 2010
- kbexpertiseinter kbtshoot kbsurveynew kbprb KB982705