Class PivotFilter

PivotFilter

Access and modify pivot table filters.

Methods

MethodReturn typeBrief description
getFilterCriteria()FilterCriteriaReturns the filter criteria for this pivot filter.
getPivotTable()PivotTableReturns the PivotTable that this filter belongs to.
getSourceDataColumn()IntegerReturns the number of the source data column this filter operates on.
remove()voidRemoves this pivot filter from the pivot table.
setFilterCriteria(filterCriteria)PivotFilterSets the filter criteria for this pivot filter.

Detailed documentation

getFilterCriteria()

Returns the filter criteria for this pivot filter.

Return

FilterCriteria — the filter criteria for this pivot filter


getPivotTable()

Returns the PivotTable that this filter belongs to.

Return

PivotTable — the pivot table this filter belongs to


getSourceDataColumn()

Returns the number of the source data column this filter operates on. These indices are 1-based, for example if this filter applies to data in column A of the spreadsheet this method returns "1."

Return

Integer — the number of the source data column this filter applies to


remove()

Removes this pivot filter from the pivot table.


setFilterCriteria(filterCriteria)

Sets the filter criteria for this pivot filter.

Parameters

NameTypeDescription
filterCriteriaFilterCriteriaThe filter criteria to set.

Return

PivotFilter — the pivot filter for chaining

发送以下问题的反馈:

此网页
Apps Script
Apps Script
需要帮助?请访问我们的支持页面