CalculatedMember and CalculatedMembers Members

Use the CalculatedMembers collection to add new calculated members to an OLAP pivot table. Use the PivotTable object’s CalculatedMembers property to get a reference to this collection. Use the CalculatedMember object to get the member’s formula and to delete calculated members. The CalculatedMembers collection and CalculatedMember object have the following members. The key member (shown in bold) is covered in the following reference section:

Warning

CalculatedMembers and CalculatedMember apply only to OLAP pivot tables.

1 Collection only

2 Object and collection

Add 1

Application 2

Count 1

Creator 2

Delete

Formula

IsValid

Item 1

Name

Parent 2

SolveOrder

SourceName

Type

 

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial