BaseField Property

Applies To

PivotField Object.

Description

Returns or sets the base field for the custom calculation. Valid only for data fields. Read-write.

Example

This example sets the data field in the PivotTable on Sheet1 to calculate the difference from the base field, sets the base field to the field named "ORDER_DATE," and sets the base item to the item named "5/16/89."

Worksheets("Sheet1").Range("A3").PivotField.Calculation = _
    xlDifferenceFrom
Worksheets("Sheet1").Range("A3").PivotField.BaseField = "ORDER_DATE"
Worksheets("Sheet1").Range("A3").PivotField.BaseItem = "5/16/89"