2.5.260 SXPI_Item
The SXPI_Item structure specifies information about a pivot field and its filtering on the page axis of a PivotTable view.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.