Skip to content

Latest commit

 

History

History
40 lines (22 loc) · 1.02 KB

Excel.PivotTable.CalculatedMembersInFilters.md

File metadata and controls

40 lines (22 loc) · 1.02 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotTable.CalculatedMembersInFilters property (Excel)
vbaxl10.chm235202
vbaxl10.chm235202
Excel.PivotTable.CalculatedMembersInFilters
1f28b21d-d079-e37a-563e-473e6b57bccd
05/08/2019
medium

PivotTable.CalculatedMembersInFilters property (Excel)

Returns or sets whether to evaluate calculated members from OLAP servers in filters. Read/write.

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.

[!includeSupport and feedback]