如果为 True(默认),则可以查看联机分析处理 (OLAP) 数据透视表的计算成员。Boolean类型,可读写。
expression.ViewCalculatedMembers
expression 必需。该表达式返回一个 PivotTable 对象。
本示例确定是否能在数据透视表上查看计算成员,并通知用户。本示例假定数据透视表位于活动工作表上。
Sub CheckViewCalculatedMembers()
Dim pvtTable As PivotTable
Set pvtTable = ActiveSheet.PivotTables(1)
' Determine if calculated members can be viewed.
If pvtTable.ViewCalculatedMembers = True Then
MsgBox "Calculated members can be viewed."
Else
MsgBox "Calculated members cannot be viewed."
End If
End Sub