CalculatedItems Object (Excel)
A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
A PivotTable report that contains January, February, and March items could have a calculated item named “FirstQuarter” defined as the sum of the amounts in January, February, and March.
Use the CalculatedItems method to return the CalculatedItems collection.
The following example creates a list of the calculated items in the first PivotTable report on worksheet one, along with their formulas.