Calculated Members Collection Properties

Name

Returns

Description

Count

Long

Returns the number of objects in the collection

Item

CalculatedMember

Parameter: Index As Variant. Returns a single CalculatedMember object in the CalculatedMembers collection

CalculatedMembers Collection Methods

Name

Returns

Parameters

Description

Add

Calculated Member

Name As String, Formula As String, [SolveOrder], [Type]

Adds a CalculatedField or CalculatedItem to a PivotTable

0 0

Post a comment