2.4.830 BrtSXVD14
The BrtSXVD14 record specifies additional properties of a pivot field (section 2.2.5.3.2) as specified by the SXVD rule (defined in section 2.1.7.40).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader |
|||||||||||||||||||||||||||||||
|
fFillDownLabels |
|||||||||||||||||||||||||||||||
|
fIgnorable |
|||||||||||||||||||||||||||||||
FRTHeader (4 bytes): An FRTBlank (section 2.5.55) that specifies the future record (section 2.1.6) information for this record.
fFillDownLabels (4 bytes): A Boolean (section 2.5.98.3) that specifies whether the pivot item labels are repeated for this pivot field. This field is ignored when fCompactData field and the fOutlineData field of the BrtBeginSXView (section 2.4.275) record are both equal to 0x1. This field is ignored if the pivot field is not on the row axis or the column (1) axis. For more details, see section 2.2.5.3.8.3. This value MUST be one of the values specified in the following table.
-
Value
Meaning
0x00000000
The item labels are not repeated.
0x00000001
The item labels are repeated for each nested item.
-
fIgnorable (4 bytes): A Boolean that specifies whether the pivot field as specified by the instance of the SXVD rule (defined in section 2.1.7.40) that contains this record SHOULD<51> be ignored.
-
If this field is equal to 1, there MUST exist an SXDI (section 2.1.7.40) rule as specified by the PivotTable (section 2.1.7.40) part ABNF which has a BrtBeginSXDI (section 2.4.243) record with an isxvdData field equal to the pivot field index of this pivot field. Additionally, this SXDI rule MUST contain a BrtSXDI14 (section 2.4.815) record with an isxvd field greater than or equal to 0.
-
The preceding BrtBeginSXVD record (section 2.4.272) MUST have an sxaxis.sxaxisData field equal to 1, and all other fields MUST be equal to 0.
For more details, see sections 2.2.5.2.7.1 (Measures) and 2.4.815 (BrtSXDI14).