CalculatedMember.SolveOrder Property

Syntax

expression.SolveOrder

expression A variable that represents a CalculatedMember object.

Example

This example determines the solve order for a calculated member and notifies the user. The example assumes a PivotTable exists on the active worksheet.

Visual Basic for Applications

Visual Basic for Applications
`Sub CheckSolveOrder() Dim pvtTable As PivotTable Set pvtTable = ActiveSheet.PivotTables(1) ' Determine solve order and notify user. If pvtTable.CalculatedMembers.Item(1).SolveOrder = 0 Then MsgBox "The solve order is set to the default value." Else MsgBox "The solve order is not set to the default value." End If End Sub`

Sub CheckSolveOrder() Dim pvtTable As PivotTable Set pvtTable = ActiveSheet.PivotTables(1) ' Determine solve order and notify user. If pvtTable.CalculatedMembers.Item(1).SolveOrder = 0 Then MsgBox "The solve order is set to the default value." Else MsgBox "The solve order is not set to the default value." End If End Sub

solve solve order solveorder solveorder property

Returns a Long specifying the value of the calculated member's solve order MDX (Mulitdimensional Expression) argument. The default value is zero. Read-only.

See also: