The data in the fields you drag to the ROW and COLUMN areas become the row and column labels of your PivotTable report. When you drag a field to the PAGE area, you create a drop-down list that you can use to filter for specific values in the field. If you want to change the layout after you finish creating the PivotTable report, you can return to this step easily. Just click PivotTable Report on the Data menu.
The current selection includes one or more calculated members that cannot be manually filtered. To apply the filter to the ...
The current selection is not within a refreshable region of the workbook. Select a refreshable region, such as a PivotTable, ...
The custom group field '|0' appears between the Top/Bottom filtered field '|1' and its filter context '|2'. Fields between ...
The data in one or more mapped XML lists exceeds the maximum limit. Open the XML Spreadsheet in Excel and reduce the amount ...
The data in the fields you drag to the ROW and COLUMN areas become the row and column labels of your PivotTable report. When ...
The data mapped on this worksheet is associated with one or more bindings that might also be mapped onto other worksheets. ...
The data range is too complex to be displayed. If a new range is selected, it will replace all of the series in the Series ...
The data retrieval services adapter retrieving your data had an unrecoverable error. Contact product support to determine ...
The data server returned a non-specific error when trying to execute your query. Check the format and content of your query ...