2.4.285 SxFilt
The SxFilt record specifies information for a PivotTable rule filter.
See SxRule for more information about PivotTable views that this record applies to.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
E |
iDim |
isxvd |
F |
G |
H |
||||||||||||||||||||||
|
grbitSbt |
cisxvi |
||||||||||||||||||||||||||||||
A - sxaxisRw (1 bit): A bit that specifies whether this filter refers to the row axis. MUST be zero if sxaxisCol is 1, if sxaxisPage is 1, or if sxaxisData is 1.
B - sxaxisCol (1 bit): A bit that specifies whether this filter refers to the column axis. MUST be zero if sxaxisRw is 1, if sxaxisPage is 1, or if sxaxisData is 1.
C - sxaxisPage (1 bit): A bit that specifies whether this filter refers to the page axis. MUST be zero if sxaxisRw is 1, if sxaxisCol is 1, or if sxaxisData is 1.
D - sxaxisData (1 bit): A bit that specifies whether this filter refers to the value axis. MUST be zero if sxaxisRw is 1, if sxaxisCol is 1, or if sxaxisPage is 1.
E - reserved1 (2 bits): MUST be zero, and MUST be ignored.
iDim (10 bits): A signed integer that specifies the zero-based position of the PivotTable field within the PivotTable axis specified by sxAxis. MUST be greater than or equal to 0 and less than or equal to 31.
isxvd (10 bits): A signed integer that specifies the data field, pivot field, or cache field that this filter refers to. MUST be greater than or equal to 0 and less than or equal to 255 or equal to -2. MUST be a value from the following table:
-
Value
Value of the fCacheBased field of the preceding SxRule record
Meaning
-2
MUST be 0
Specifies that this rule refers to the data field.
A value greater than or equal to zero
0
Specifies a pivot field index as specified by pivot fields. The pivot field index specifies which pivot field is referenced by this filter.
A value greater than or equal to zero
1
Specifies a cache field index as specified by cache fields. The cache field index specifies which cache field is referenced by this filter.
F - fSelected (1 bit): A bit that specifies whether the header of the PivotTable field this filter refers to is included in the PivotTable rule that this record belongs to.
G - reserved2 (1 bit): MUST be zero, and MUST be ignored.
H - reserved3 (4 bits): MUST be zero, and MUST be ignored.
grbitSbt (2 bytes): A signed integer that specifies the set of subtotals used in this filter. MUST be one of the following bits, or a combination of the following bits. DEFAULT MUST be combined only with DATA, BLANK, or both.
-
Bits
Meaning
0x0001
DATA
0x0002
DEFAULT
0x0004
SUM
0x0008
COUNTA
0x0010
AVERAGE
0x0020
MAX
0x0040
MIN
0x0080
PRODUCT
0x0100
COUNT
0x0200
STDEV
0x0400
STDEVP
0x0800
VAR
0x1000
VARP
0x4000
BLANK
cisxvi (2 bytes): An unsigned integer that specifies the number of indexes in the SxItm record that follows this record.