Export (0) Print
Expand All
Expand Minimize

2.5.260 SXPI_Item

Office

The SXPI_Item structure specifies information about a pivot field and its filtering on the page axis of a PivotTable view.


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

isxvd

isxvi

idObj

isxvd (2 bytes): A signed integer that specifies a pivot field index as specified by Pivot Fields. The referenced pivot field is specified to be on the page axis. MUST be greater than or equal to zero and less than the cDim field of the SxView record of the PivotTable view.

isxvi (2 bytes): A signed integer that specifies the pivot item used for the page axis filtering. MUST be a value from the following table:

Value

Meaning

0x0000 to 0x7FFC

This value specifies a pivot item index that specifies a pivot item in the pivot field specified by isxvd. The referenced pivot item specifies the page axis filtering for the pivot field.

0x7FFD

This value specifies all pivot items, see page axis for filtering that applies.

For a non-OLAP PivotTable view the value MUST be 0x7FFD or greater than or equal to zero and less than the cItm field of the Sxvd record of the pivot field. Otherwise the value MUST be 0x7FFD.

idObj (2 bytes): A signed integer that specifies the object identifier of the Obj record with the page item drop-down arrow.

Show:
© 2014 Microsoft