2.2.5.4.8.1.1 Label Filters

  • Article

A label filter specifies a criterion that is applied to pivot item (section 2.2.5.4.4) captions to determine which pivot items (section 2.2.5.4.4) are included in the calculation of values for the PivotTable view (section 2.2.5.4) and displayed in the PivotTable report (section 2.2.5).

A label filter is specified by an SXAddl_SXCSXFilter12_SXDSXFilter record (section 2.4.273.82) 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.4.8.1.3), but the order of label filters is not specified.

If a caption is specified, the label filter is applied to the stName field in the SXVI records (section 2.4.312) associated with the pivot items (section 2.2.5.4.4). If captions are not specified for the pivot items (section 2.2.5.4.4), the label filter is applied to the values of the cache items (section 2.2.5.3.6) associated with these pivot items (section 2.2.5.4.4).

A label filter can be applied to member properties (section 2.2.5.4.6). The isxvdMProp field of the SXAddl_SXCSXFilter12_SXDSXFilter record (section 2.4.273.82) specifies the member property (section 2.2.5.4.6) on which this label filter is applied.