Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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)

'Usage
Public Class alculatedItemsImplementation
	Implements CalculatedItems
End Class
Dim alculatedItemsImplementation1 As New alculatedItemsImplementation()

public interface CalculatedItems
public interface CalculatedItems
public interface CalculatedItems

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.


Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

ADD
Show:
© 2015 Microsoft