PivotField.CalculatedItems Method

Returns a CalculatedItems collection that represents all the calculated items in the specified PivotTable report. Read-only.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function CalculatedItems As CalculatedItems
'Usage
Dim instance As PivotField
Dim returnValue As CalculatedItems

returnValue = instance.CalculatedItems()
CalculatedItems CalculatedItems()

Return Value

Type: Microsoft.Office.Interop.Excel.CalculatedItems

Remarks

For OLAP data sources, this method returns a zero-length collection.

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace