Share via

PivotField.BaseField Property

  • Article
Excel Developer Reference

Returns or sets the base field for a custom calculation. This property is valid only for data fields. Read/write Variant.

Syntax

expression.BaseField

expression   A variable that represents a PivotField object.

Remarks

This property is not available for OLAP data sources.

Example

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

Visual Basic for Applications 
  With Worksheets("Sheet1").Range("A3").PivotField
    .Calculation = xlDifferenceFrom
    .BaseField = "ORDER_DATE"
    .BaseItem = "5/16/89"
End With

See Also