2.2.5.4.11 PivotTable Rules

Office

A PivotTable rule is used to specify ranges of cells in the PivotTable report (section 2.2.5). A PivotTable rule is specified by the sequence of records that conform to the PIVOTRULE rule (section 2.1.7.20.6) or by an SxcSXRule class (section 2.2.5.1.1.1.11). Each PivotTable rule has references to specific area of a PivotTable report (section 2.2.5), pivot fields  (section 2.2.5.4.3), pivot items (section 2.2.5.4.4), data items (section 2.2.5.4.9.5.1), or cache items (section 2.2.5.3.6). These references are used to determine the ranges of cells in the PivotTable report (section 2.2.5). The various areas of the PivotTable report (section 2.2.5) specified in the Location and Body section and the pivot lines (section 2.2.5.4.10.3) can be used in this determination.

The SxRule (section 2.4.301) or SXAddl_SXCSXrule_SXDSXrule (section 2.4.273.99) records specify information for a PivotTable rule, including restrictions such as what areas of the PivotTable report (section 2.2.5) the PivotTable rule applies to. In the case of the SxRule record (section 2.4.301) the fCacheBased field specifies whether the PivotTable rule specifies cache items (section 2.2.5.3.6) instead of pivot items (section 2.2.5.4.4).

A PivotTable rule can have PivotTable rule filters. A PivotTable rule filter is specified by the sequence of records that conform to a PRFILTER rule (section 2.1.7.20.6) or an SxcSXFilt class (section 2.2.5.1.1.1.12). A PivotTable rule filter specifies a set of pivot items (section 2.2.5.4.4), data items (section 2.2.5.4.9.5.1), or cache items (section 2.2.5.3.6) for an individual pivot field (section 2.2.5.4.3), data field (section 2.2.5.4.9.5.2), or cache field (section 2.2.5.3.5).

Ranges of cells that are associated, in the PivotTable report (section 2.2.5), with any pivot item (section 2.2.5.4.4), data item (section 2.2.5.4.9.5.1), or cache item (section 2.2.5.3.6) from a PivotTable rule filter and that meet other restrictions as specified by the SxFilt (section 2.4.285) or SXAddl_SXCSXfilt_SXDSXfilt (section 2.4.273.77) record are associated with the PivotTable rule filter. Ranges of cells that are associated with every PivotTable rule filter of the PivotTable rule and that meet other restrictions of the PivotTable rule are the ranges of cells specified by the PivotTable rule.

A range of cells is associated with a particular cache item (section 2.2.5.3.6) if it is associated with the pivot item (section 2.2.5.4.4) that has an association with that cache item (section 2.2.5.3.6).

Show: