PivotTable.CalculatedMembersInFilters Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets whether to evaluate calculated members from OLAP servers in filters.

public:
 property bool CalculatedMembersInFilters { bool get(); void set(bool value); };

public bool CalculatedMembersInFilters { get; set; }

Public Property CalculatedMembersInFilters As Boolean

Property Value

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.

Applies to