Change the amount of detail displayed in a PivotChart report

Microsoft Office Excel 2003

previous page next page
Button image on the PivotTable toolbar, and look at the PivotTable Field List window.

  • If the field list has Dimension field icon and Data field icon icons, the report has OLAP source data.

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

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

ShowDisplay or hide different levels of detail for a field

  1. Click the associated PivotTable report for the PivotChart report.
  2. Click the field.
  3. To display or hide lower-level detail, click Show Detail Button image or Hide Detail Button image on the PivotTable toolbar.

  4. 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 Field 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.

ShowDisplay or hide property fields

  1. Click the associated PivotTable report for the PivotChart report.
  2. Click the field for which you want to display property fields.
  3. On the PivotTable toolbar, click PivotTable, and then click Property Fields.
  4. 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.
  5. In the Properties to display box, use the Up arrow and Down arrow buttons to arrange the property fields in the order you want them to appear in the report.
  6. Make sure the Show fields for this dimension in outline form check box is selected, and then click OK.
  7. If the levels for which you selected property fields aren't displayed in the report, click the field and then click Show Detail Button image on the PivotTable toolbar.

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

ShowDisplay or hide series detail

  1. Click the associated PivotTable report for the PivotChart report.
  2. Click the column field for the series for which you want to show or hide detail.
  3. On the PivotTable toolbar, click Show Detail Button image or Hide Detail Button image.
  4. If prompted, double-click the field that has the detail you want to show.

ShowDisplay or hide category item detail

  1. Right-click the category label for which you want to show or hide detail, or in a pie or doughnut chart, click the slice or ring for which you want to show or hide detail.
  2. On the shortcut menu, click Show detail category name or Hide detail category name.
  3. If prompted, double-click the field that has the detail you want to show.

Note  When you change the amount of detail displayed in a PivotChart report, some chart formatting may be lost.

previous page start next page