2.4.273.77 SXAddl_SXCSXfilt_SXDSXfilt
The SXAddl_SXCSXfilt_SXDSXfilt record specifies information for a PivotTable rule filter, for an SXCSXfilt class.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
hdr |
|||||||||||||||||||||||||||||||
|
... |
reserved1 |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
G |
reserved5 |
grbitSbt |
|||||||||||||||||||||||
|
iDim |
|||||||||||||||||||||||||||||||
|
isxvd |
|||||||||||||||||||||||||||||||
|
cisxvi |
|||||||||||||||||||||||||||||||
hdr (6 bytes): An SXAddlHdr structure. The value of hdr.sxc MUST equal 0x0D and the value of hdr.sxd MUST equal 0x14.
reserved1 (6 bytes): MUST be zero, and MUST be ignored.
A - sxaxisRw (1 bit): A bit that specifies whether the row axis is being referred to.
-
MUST be zero if the value of sxaxisCol is 1 or the value of sxaxisPage is 1 or the value of sxaxisData is 1.
B - sxaxisCol (1 bit): A bit that specifies whether the column axis is being referred to.
-
MUST be zero if the value of sxaxisRw is 1 or the value of sxaxisPage is 1 or the value of sxaxisData is 1.
C - reserved2 (1 bit): MUST be zero, and MUST be ignored.
D - sxaxisData (1 bit): A bit that specifies whether the value axis is being referred to.
-
MUST be zero if the value of sxaxisRw is 1 or the value of sxaxisCol is 1 or the value of sxaxisPage is 1.
E - fSelected (1 bit): A bit that specifies whether the header of the Pivot Field is included in the PivotTable rule filters.
F - reserved3 (1 bit): MUST be zero, and MUST be ignored.
G - reserved4 (1 bit): MUST be zero, and MUST be ignored.
reserved5 (9 bits): MUST be zero, and MUST be ignored.
grbitSbt (2 bytes): A signed integer that specifies the subtotals for this PivotTable rule filter. MUST be a value from the following table:
-
Value
Meaning
0
No subtotals are displayed.
1
Data value subtotals are displayed.
iDim (4 bytes): A signed integer that specifies the position of the Pivot Field within the axis specified by sxaxisRw, sxaxisCol, sxaxisPage, or sxaxisData. MUST be greater than or equal to -1 and less than or equal to 0x0000001F.
isxvd (4 bytes): A signed integer that specifies the Pivot Field that this PivotTable rule filter refers to. MUST be a value from the following table:
-
Value
Meaning
-2
This PivotTable rule filter refers to the data field.
-1
This PivotTable rule filter does not refer to a pivot field
0 to 255
This value specifies a pivot field index, as specified in Pivot Fields. The pivot field index specifies which pivot field this PivotTable rule filter refers to.
-
If the value is greater than or equal to zero, MUST be less than the number of pivot fields in the PivotTable view.
cisxvi (4 bytes): An unsigned integer that specifies the count of pivot item indexes in the SXAddl_SXCSXfilt_SXDSXItm record that follows this record. MUST be greater than or equal to zero. If isxvd is -1, MUST be 0.