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: September 18, 2011 - Revision: 2.0
- Microsoft SharePoint Server 2010
- Microsoft Excel 2010
|kbexpertiseinter kbtshoot kbsurveynew kbprb KB982705|