PivotTable.CalculatedMembersInFilters Property (Excel)
Returns or sets whether to evaluate calculated members from OLAP servers in filters. Read/write
Version Information
Version Added: Excel 2010
Syntax
expression .CalculatedMembersInFilters
expression A variable that represents a PivotTable object.
Return Value
Boolean
Remarks
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.