PivotTable.CalculatedMembersInFilters Property
Gets or sets whether to evaluate calculated members from OLAP servers in filters.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property CalculatedMembersInFilters As Boolean
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Boolean
value = instance.CalculatedMembersInFilters
instance.CalculatedMembersInFilters = value
bool CalculatedMembersInFilters { get; set; }
Property Value
Type: System.Boolean
true if calculated members from OLAP servers should be evaluated in filters; otherwise, false.
Remarks
Read/write.
true if calculated members are evaluated in filters; otherwise false.
The value of this property corresponds to the setting of the Evaluate calculated members from OLAP servers in filters check box on the Totals & Filters tab of the PivotTable Options dialog box for a PivotTable report based on an OLAP data source.