Share via

2.2.5.3.6.1.1 Label Filters

  • Article

A label filter specifies criteria that are applied to pivot item (section 2.2.5.3.3) captions to determine which pivot items (section 2.2.5.3.3) are included in the calculation of values for the PivotTable view (section 2.2.5.3) and displayed in the PivotTable (section 2.2.5) report.

A label filter is specified by a BrtBeginSXFILTER (section 2.4.247) record with the sxft field equal to a value in the range 0x00000004 through 0x00000011.

Label filters are applied before any value filters (section 2.2.5.3.6.1.3), but the order of label filters is not specified.

If a caption is specified for a pivot item (section 2.2.5.3.3), the label filter is applied to the displayName field of the BrtBeginSXVI (section 2.4.274) record associated with that pivot item. If a caption is not specified for a pivot item, the label filter is applied to the value of the cache item (section 2.2.5.2.3) associated with that pivot item.

A label filter can be applied to member properties. The isxvdMProp field of the BrtBeginSXFILTER record specifies the member property on which this label filter is applied.