Show All

Change the amount of detail displayed in a PivotTable report

1. Determine what kind of source data your report has: click the report, if the field list is not displayed click Show Field List on the PivotTable toolbar, and look at the PivotTable Field List window.

   If the field list has and icons, the report has OLAP source data.

   If the field list has icons, the report does not have OLAP source data.

2. For OLAP reports, display or hide different levels of detail for a field.

   How?

   1. Click the field.
   2. To display or hide lower-level detail, click Show Detail or Hide Detail on the PivotTable toolbar.
   3. To hide upper levels of detail, right-click the field button for the lowest level you want to hide, and then click Hide levels on the shortcut menu.

      The level you clicked and all higher levels in the dimension are removed from view, and the dropdown arrow is also hidden.

      To redisplay hidden upper levels, right-click any field button in the dimension, and then click Show levels on the shortcut menu.

   Note  If you hide and then redisplay levels, any renamed items revert to their original names.

   For non-OLAP reports, do one or more of the following:

   Display or hide detail data for an item

   1. Click the item.
   2. On the PivotTable toolbar, click Show Detail or Hide Detail .
   3. If prompted, click the field that has the detail data you want to see.

   Display or hide detail for a data cell

   1. Double-click a cell in the data area.

      Microsoft Excel places the detail data summarized in the cell on a new worksheet.

   2. To hide the detail data, delete the new worksheet.

   Note  To prevent access to this detail, click PivotTable on the PivotTable toolbar, click Table Options, and then clear the Enable drill to details check box.

3. For OLAP reports, display or hide property fields, if available from your server cube.

   How?

   1. Click the field in the dimension for which you want to display property fields.
   2. On the PivotTable toolbar, click PivotTable, and then click Property Fields.
   3. In the Choose properties from level list, click each level for which you want to display property fields, and then double-click the property fields you want to see.
   4. In the Properties to display box, use the and buttons to arrange the property fields in the order you want them to appear in the report.
   5. Make sure the Show fields for this dimension in outline form check box is selected, and then click OK.
   6. If the levels for which you selected property fields aren't displayed in the report, click the field and then click Show Detail on the PivotTable toolbar.

   Note  In column fields, property fields are only displayed for items in the lowest level of detail displayed in the report. To display property fields for other levels, move the field to the row area.