Each pivot PivotTable field must have a unique display name. If the display name of a Row row or Column column label is not the name of its SourceFieldsource field, the display name of the SourceField source field that the label was created from will change to match the Row row or Column column label name. This only affects the display name of the SourceField source field as seen in Excel. The underlying name of the SourceFieldsource field, which is pulled from the header names of the columns in the data source, will not be affected. Changing the DisplayName for a ColumnLabel , RowLabel , or PageField will also change the displayed name for the SourceField . This is the same as the Excel behavior. This cannot be set on a CalculatedField ValuesLabel . The default value returned by a CalculatedField ValuesLabel is "Values". |