2.2.5.4.8.1 Advanced Filters

  • Article

An advanced filter specifies a user-defined criterion that is used to determine the pivot items (section 2.2.5.4.4) of a pivot field (section 2.2.5.4.3) that are included when calculating values for the PivotTable view (section 2.2.5.4) and that are displayed in the PivotTable report (section 2.2.5).

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

An advanced filter is specified by the SXCSXFilter12 class section. The isxvd field of the SXAddl_SXCSXFilter12_SXDSXFilter record (section 2.4.273.82) specifies the pivot field (section 2.2.5.4.3) associated with the advanced filter.

Advanced filters MUST NOT be applied to pivot fields (section 2.2.5.4.3) of a PivotTable view (section 2.2.5.4) if the PivotCache functionality level (section 2.2.5.3.1) of the associated PivotCache (section 2.2.5.4.1) is less than 3. Advanced filters MUST NOT be applied to an OLAP PivotTable view (section 2.2.5.4.2) with a value of 0 for the fSrvSupportSubquery field of the SXAddl_SXCCache_SXDInfo12 record (section 2.4.273.7) of the associated PivotCache (section 2.2.5.4.1).

There are three types of advanced filters: label filter (section 2.2.5.4.8.1.1), date filter (section 2.2.5.4.8.1.2), and value filter (section 2.2.5.4.8.1.3).

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