CalculatedItems Interface
A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00024421-0000-0000-C000-000000000046")> _
Public Interface CalculatedItems _
Inherits IEnumerable
'Usage
Dim instance As CalculatedItems
[InterfaceTypeAttribute()]
[GuidAttribute("00024421-0000-0000-C000-000000000046")]
public interface CalculatedItems : IEnumerable
Remarks
For example, a PivotTable report that contains January, February, and March items could have a calculated item named “FirstQuarter” that is defined as the sum of the amounts in January, February, and March.
Use the CalculatedItems method to return the CalculatedItems collection.
Use CalculatedItems(index), where index is the name or index number of the field, to return a single PivotItem object from the CalculatedItems collection.