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]".

Visual Basic for Applications 
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
calculated calculated members calculatedmembers calculatedmembers property

See also: