Поделиться через

PivotTable.CalculatedMembers Property

  • Статья
Excel Developer Reference

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

Visual Basic for Applications 
  Sub UseCalculatedMember()

Dim pvtTable As PivotTable

Set pvtTable = ActiveSheet.PivotTables(1)

' Add the calculated member.
pvtTable.<strong>CalculatedMembers</strong>.Add Name:="[Beef]", _
    Formula:="'{[Product].[All Products].Children}'", _
    Type:=xlCalculatedSet



End Sub

See Also