PivotTable.CalculatedMembers Property (Excel)
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 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}'", _
Type:=xlCalculatedSet
End Sub