2.2.5.4.10.3 Pivot Lines

  • Article

A pivot line specifies a collection of pivot line entries (section 2.2.5.4.10.4) for a single row or column in the PivotTable report (section 2.2.5).

A pivot line in the column area (section 2.2.5.4.10.1.2) is the range defined by the intersection of:

  • A column.

  • A set of cells in the column area (section 2.2.5.4.10.1.2). These are cells that contain pivot items (section 2.2.5.4.4), data items (section 2.2.5.4.9.5.1), blank cells, or a grand total.

A pivot line in the row area (section 2.2.5.4.10.1.1) is the range defined by the intersection of:

  • A row.

  • A set of cells in the row area (section 2.2.5.4.10.1.1). These are cells that contain pivot items (section 2.2.5.4.4), data items (section 2.2.5.4.9.5.1), blank cells, or a grand total.

A pivot line is specified by a sequence of records that conforms to the PIVOTLI rule (section 2.1.7.20.5). If either the cRw field or the cCol field of the associated SxView record (section 2.4.313) is greater than 0, then two PIVOTLI rules (section 2.1.7.20.5) MUST exist in the sequence of records that conforms to the PIVOTCORE rule (section 2.1.7.20.5), otherwise a PIVOTLI rule (section 2.1.7.20.5) MUST NOT exist in the PIVOTCORE rule (section 2.1.7.20.5).

If PIVOTLI rules (section 2.1.7.20.5) for a PivotTable view (section 2.2.5.4) exist, the first PIVOTLI rule (section 2.1.7.20.5) specifies the collection of pivot lines for the row area (section 2.2.5.4.10.1.1). The order of the SXLIItem structures (section 2.5.259) in the rgsxli field of the SXLI record (section 2.4.293) specifies the top to bottom order of the pivot lines of the row area (section 2.2.5.4.10.1.1).

If PIVOTLI rules (section 2.1.7.20.5) for a PivotTable view (section 2.2.5.4) exist, the second PIVOTLI rule (section 2.1.7.20.5) specifies the collection of pivot lines for the column area (section 2.2.5.4.10.1.2). The order of the SXLIItem structures (section 2.5.259) in the rgsxli field of the SXLI record (section 2.4.293) specifies the logical left to logical right order of the pivot lines of the column area (section 2.2.5.4.10.1.2).

Each individual pivot line is specified by an SXLIItem structure (section 2.5.259) in the rgsxli field of the associated SXLI record (section 2.4.293). Each pivot line contains a number of pivot line entries (section 2.2.5.4.10.4). Pivot line entries (section 2.2.5.4.10.4) are specified by the rgisxvi field of the SXLIItem structure (section 2.5.259).

The first pivot line in the row area (section 2.2.5.4.10.1.1) or the column area (section 2.2.5.4.10.1.2) MUST have a cSic field of its associated SXLIItem structure (section 2.5.259) equal to 0.

The following shows an example of a PivotTable report (section 2.2.5) and the pivot lines corresponding to each row in the row area (section 2.2.5.4.10.1.1).

PivotTable and a table illustrating each pivot line

Figure 16: PivotTable and a table illustrating each pivot line