Edit

Share via

PivotTable.CalculatedMembers property (Excel)

  • Article

Returns a CalculatedMembers collection representing all the calculated members and calculated measures for an OLAP PivotTable.

Syntax

expression.CalculatedMembers

expression A variable that represents a PivotTable object.

Remarks

This property is used for Online Analytical Processing (OLAP) sources; a non-OLAP source will return a run-time error.

Example

This example adds a set to the PivotTable. It assumes that a PivotTable exists on the active worksheet that is connected to an OLAP data source that contains a field titled [Product].[All Products].

Sub UseCalculatedMember() 
 
 Dim pvtTable As PivotTable 
 
 Set pvtTable = ActiveSheet.PivotTables(1) 
 
 ' Add the calculated member. 
 pvtTable.CalculatedMembers.Add Name:="[Beef]", _ 
 Formula:="'{[Product].[All Products].Children}'", _ 
 Type:=xlCalculatedSet 
 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.