PivotTable.CalculatedMembers Property (Excel)

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


expression. CalculatedMembers

expression A variable that represents a PivotTable object.


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


This example adds a set to the PivotTable. It assumes a PivotTable exists on the active worksheet that is connected to an OLAP data source which 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}'", _ 
End Sub

See also

PivotTable Object