Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.4.291 SxItm

Office

The SxItm record specifies references to pivot items, data items, or cache items as part of a PivotTable rule filter.

If this record exists, the cisxvi field of the preceding SxFilt MUST be greater than 0.

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

rgisxvi (variable)

...

rgisxvi (variable): An array of 2-byte unsigned integers that specifies pivot items, data item, or cache items associated with ranges of cells included in the PivotTable rule. The array MUST be sorted in ascending order. The size of the array MUST be equal to the value of the cisxvi field of the preceding SxFilt record. Each unsigned 2-byte integer in the array MUST be less than or equal to 32500, or equal to 32767. The value 32767 specifies that there is no associated pivot item, data item, or cache item with the index. For more information, see PivotTable Rules. The meaning of this field is specified in the following table:

Value of the isxvd field of the precedingSxFilt record

Value of the fCacheBased field of the preceding SxRule record

Meaning of the index

-2

Not used

A data item index that specifies a data item associated with ranges of cells included in the PivotTable rules. MUST be less than the value of the cDimData field of the associated SxView record.

>= 0

0

A pivot item index that specifies a pivot item in the pivot field specified by the isxvd field of the SxFilt record. The referenced pivot item is associated with ranges of cells included in the PivotTable rule. MUST be less than the cItems field of the Sxvd record.

1

A cache item index, as specified by cache items, within the cache field specified by the isxvd field of the SxFilt record in the current PivotCache. The referenced cache item is associated with ranges of cells included in the PivotTable rule. MUST be less than the total number of cache items within the cache field associated with the pivot field specified by the isxvd field of the SxFilt record.

Show:
© 2015 Microsoft