2.2.5.3.6.1 Advanced Filters

  • Article

An advanced filter specifies a user-defined criterion that is used to determine the pivot items (section 2.2.5.3.3) of a pivot field (section 2.2.5.3.2) that are included in subtotal calculations for the PivotTable view (section 2.2.5.3) and that are displayed in the PivotTable (section 2.2.5) report.

Only advanced filters that are associated with pivot fields that are located on the row axis or the column (1) axis are applied when the PivotTable view is calculated.

An advanced filter is specified by the sequence of records that conforms to the SXFILTER rule (defined in section 2.1.7.40), and the isxvd field of the BrtBeginSXFILTER (section 2.4.247) record specifies the pivot field associated with the advanced filter.

Advanced filters MUST NOT be applied to pivot fields of a PivotTable view if the value of the bVerSxMacro field of the BrtBeginSXView (section 2.4.275) record corresponding to the PivotTable view is less than 3, or OLAP PivotTable views with a value of 0 for the fSupportSubquery field of the corresponding BrtBeginPivotCacheDef (section 2.4.168) record.

There are three types of advanced filters: label filter (section 2.2.5.3.6.1.1), date filter (section 2.2.5.3.6.1.2), and value filter (section 2.2.5.3.6.1.3).

A pivot field (section 2.2.5.3.2) MUST NOT have more than one associated advanced filter of the same type.