2.4.177 BrtBeginPNPair
The BrtBeginPNPair record specifies a reference to a pivot item (section 2.2.5.3.3). This record is used in a calculated item (section 2.2.5.2.6) formula (section 2.2.2), and specifies the beginning of an empty collection as defined by the PivotCache Definition (section 2.1.7.38) part ABNF.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
reserved |
ifield |
||||||||||||||||||||||||||||
|
... |
iitem |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
A - fPhysical (1 bit): A bit that specifies whether iitem specifies a cache item (section 2.2.5.2.3) index. The possible values for this field are listed in the following table.
|
Value |
Meaning |
|---|---|
|
0 |
iitem specifies a cache item index. |
|
1 |
iitem does not specify a cache item index. |
B - fRelative (1 bit): A bit that specifies whether the item is referred to by relative position rather than absolute position. If fPhysical is 0, fRelative MUST be 0, and MUST be ignored. If fPhysical is 1, fRelative MUST be a value from the following table.
-
-
-
Value
Meaning
0
Absolute position.
1
Position relative to the calculated item referring to this item.
-
-
reserved (6 bits): This value MUST be 0, and MUST be ignored.
ifield (4 bytes): An unsigned integer that is a cache field (section 2.2.5.2.2) index. This index specifies a cache field which contains the cache item associated with the pivot item specified by iitem.
iitem (4 bytes): A signed integer that specifies a pivot item of the PivotTable view (section 2.2.5.3) associated with this record as specified in section 2.2.5.3.1. This pivot item is used in a calculated item formula (section 2.2.2). If more than one PivotTable view is associated with this record, iitem specifies a pivot item for each such PivotTable view.
If the value of fPhysical is 0, iitem is a cache item index, and specifies the pivot item associated with that cache item.
Otherwise if the value of fRelative is 0 or if no pivot item in the visible item collection has a pivot item index smaller than the pivot item index of the current pivot item, iitem is a visible item index. Otherwise, the pivot item specified by iitem is the pivot item whose visible item index equals the value of iitem + 1 + the largest visible item index whose associated pivot item has a pivot item index smaller than the pivot item index of the current pivot item. If this value is less than 0 or greater than or equal to the number of elements in the visible item collection, no pivot item is specified.
The current pivot item is the pivot item in the current pivot field (section 2.2.5.3.2) that corresponds to the calculated item that contains this record.
The current pivot field is the pivot field of the PivotTable view associated with the cache field specified by ifield.
The visible item collection is the ordered collection of all pivot items (section 2.2.5.3.3) specified by the sequence of records that conforms to the SXVIS rule (defined in section 2.1.7.40) associated with the current pivot field that satisfy the following criteria:
The value of the fHidden field of the BrtBeginSXVI (section 2.4.274) record associated with the pivot item is 0.
The value of the fMissing field of the BrtBeginSXVI record associated with the pivot item is 0 or the value of the fShowAllItems field of the BrtBeginSXVD record associated with the current pivot field is 1.
The value of the itmtype field of the BrtBeginSXVI record associated with the pivot item is PITDATA (defined in section 2.5.105).
A visible item index is specified to be the zero-based index of a pivot item in the visible item collection.