PivotField.BaseItem property (Excel)
Returns or sets the item in the base field for a custom calculation. Valid only for data fields. Read/write Variant.
expression A variable that represents a PivotField object.
This property is not available for OLAP data sources.
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."
With Worksheets("Sheet1").Range("A3").PivotField .Calculation = xlDifferenceFrom .BaseField = "ORDER_DATE" .BaseItem = "5/16/89" End With
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.