Export (0) Print
Expand All
Expand Minimize

2.4.285 SxFilt

Office

The SxFilt record specifies information for a PivotTable rule filter.

See SxRule for more information about PivotTable views that this record applies to.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

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.

Show:
© 2014 Microsoft