Share via

2.2.5.3.6.1.3 Value Filters

  • Article

A value filter specifies a criterion that is applied to values of a data item (section 2.2.5.3.7.5.1) for pivot items (section 2.2.5.3.3) of the pivot field (section 2.2.5.3.2) that the value filter is applied to. The value filter determines which pivot items are included in the subtotal calculation of the PivotTable view (section 2.2.5.3) and displayed in the PivotTable view report.

A value filter is specified by the sequence of records specified by the sequence of records that conforms to the SXFILTER rule (defined in section 2.1.7.40) that contain a BrtBeginSXFILTER (section 2.4.247) record with the sxft field equal to a value in one of the following the ranges: 0x00000001 through 0x00000003 or 0x00000012 through 0x00000019.

Value filters are applied after manual filters (section 2.2.5.3.5), date filters section 2.2.5.3.6.1.2), and label filters (section 2.2.5.3.6.1.1) are applied. Value filters are applied in the order in which they are specified in the collection specified by the sequence of records that conforms to the SXFILTERS rule (defined in section 2.1.7.40). The subtotals generated as a result of a value filter being applied are used to evaluate the next value filter specified in the SXFILTERS rule.