Share via

2.2.5.4.8.1.3 Value Filters

  • Article

A value filter specifies a criterion that is applied to values of a data item (section 2.2.5.4.9.5.1) for pivot items (section 2.2.5.4.4) of the pivot field (section 2.2.5.4.3) that the value filter is applied to. The value filter determines which pivot items (section 2.2.5.4.4) are included when calculating values for the PivotTable view (section 2.2.5.4) and displayed in the PivotTable view (section 2.2.5.4) report.

A value filter is specified by the SXAddl_SXCSXFilter12_SXDSXFilter records (section 2.4.273.82) with the sxft field equal to a value in one of the following the ranges: from 0x00000001 through 0x00000003 or from 0x00000012 through 0x00000019.

Value filters are applied after manual filters (section 2.2.5.4.7), date filters (section 2.2.5.4.8.1.2) and label filters (section 2.2.5.4.8.1.1) are applied. Value filters are applied in the order in which they are specified in the SXCSXFilter12 class section. Value filtering takes previous filtering into account when evaluating filters.