Syntax

expression.CalculatedItems

expression A variable that represents a PivotField object.

Return Value
CalculatedItems

Remarks

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

Example

This example creates a list of calculated items and their formulas.

Visual Basic for Applications 
Set pt = Worksheets(1).PivotTables(1) For Each ci In pt.PivotFields("Sales").CalculatedItems r = r + 1 With Worksheets(2) .Cells(r, 1).Value = ci.Name .Cells(r, 2).Value = ci.Formula End With Next
calculated calculated items Calculated Items Method CalculatedItem calculateditem method calculateditems calculateditems method list all calculated items reference every calculated item return collection all calculated items pivot table

See also: