Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
50 lines (29 sloc) 1.02 KB
title keywords f1_keywords ms.prod api_name ms.assetid ms.date
PivotField.BaseItem Property (Excel)
vbaxl10.chm240096
vbaxl10.chm240096
excel
Excel.PivotField.BaseItem
11561507-043a-2b64-1b60-3cdbd93a656c
06/08/2017

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 .

Syntax

expression. BaseItem

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."

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

See also

PivotField Object