Managing label and data headings
When row and column labels are added to a Pivot section, the row and column headings are not shown by default. However, when an element is added to the Fact section, the heading of the fact is shown above every column of facts. The Pivot provides the ability to manage the headings for both the labels and facts, named Corner Labels and Data Labels.
Data labels
Data labels are used to add or remove fact headings and to select the position of the fact columns in the Pivot. Three options can be selected for managing data labels including:
None: The Fact records are shown as columns and no header record is included.
Column: The Fact records are shown as columns and column headings are added above the fact columns.
Row: The Fact records are moved to the rows and the column headings appear as row labels.
The names of the Data labels can be modified by double-clicking on the label name and entering the desired name into the pop-up window. The original name can be...
