PivotTable.AddDataField(Object, Object, Object) Method
Definition
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 PivotFieldParameters
- 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.