Edit

Share via


CalculatedMembers Interface

Definition

A collection of all the CalculatedMember objects on the specified PivotTable.

public interface class CalculatedMembers : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("00024454-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface CalculatedMembers : System.Collections.IEnumerable
Public Interface CalculatedMembers
Implements IEnumerable
Attributes
Implements

Remarks

Each CalculatedMember object represents a calculated member or calculated measure.

Use the CalculatedMembers property of the PivotTable object to return a CalculatedMembers collection.

Properties

_Default[Object]

Reserved for internal use.

Application

Returns an Application object that represents the Microsoft Excel application.

Count

Returns the number of objects in the collection.

Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Item[Object]

Returns a single object from a collection.

Parent

Returns the parent object for the specified object.

Methods

Add(String, String, Object, Object)

Adds a calculated field or calculated item to a PivotTable.

Add2(String, Object, Object, Object, Object, Object, Object)

Reserved for internal use.

AddCalculatedMember(String, Object, Object, Object, Object, Object, Object, Object, Object)

Adds a calculated field or calculated item to a PivotTable.

GetEnumerator()

Applies to