Controlling the Display of the Measure Headings
By default, when a pivot table displays a level on columns and displays measures, the pivot table may or may not include a heading for the measures, as follows:
-
If the pivot table has only one measure, the measure name is not shown. For example:
-
If the pivot table has multiple measures, the measure names are shown. For example:
You can control this behavior. To do so, click the Options button in the Measures box. The system displays a dialog box; for this discussion, use the options in the section Display measure headers. Choose one of the following options:
-
If More Than 1 Measure — The system displays the measure name if there is more than one measure, but does not display the name if there is only one measure.
-
Always — The system always displays the measure name.
-
Never — The system never displays the measure name.
These options apply only when the pivot table also displays another item on columns, as in the examples shown here.