PivotTable.AddDataField(Object, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Adds a data field to a PivotTable report. Returns a PivotField object that represents the new data field.

public Microsoft.Office.Interop.Excel.PivotField AddDataField (object Field, object Caption, object Function);

Public Function AddDataField (Field As Object, Optional Caption As Object, Optional Function As Object) As PivotField

Parameters

Field: Object

Required Object. The unique field on the server. If the source data is Online Analytical Processing (OLAP), the unique field is a cube field. If the source data is non-OLAP (non-OLAP source data), the unique field is a PivotTable field.

Caption: Object

Optional Object. The label used in the PivotTable report to identify this data field.

Function: Object

Optional Object. The function performed in the added data field.

Returns

PivotField

Applies to