2.4.312 SXVI

The SXVI record specifies information about a pivot item.

itmType (2 bytes):  A signed integer that specifies the pivot item type. The value MUST be one of the following values:

Value	Name	Meaning
0x0000	itmtypeData	A data value
0x0001	itmtypeDEFAULT	Default subtotal for the pivot field
0x0002	itmtypeSUM	Sum of values in the pivot field
0x0003	itmtypeCOUNTA	Count of values in the pivot field
0x0004	itmtypeAVERAGE	Average of values in the pivot field
0x0005	itmtypeMAX	Max of values in the pivot field
0x0006	itmtypeMIN	Min of values in the pivot field
0x0007	itmtypePRODUCT	Product of values in the pivot field
0x0008	itmtypeCOUNT	Count of numbers in the pivot field
0x0009	itmtypeSTDEV	Statistical standard deviation (estimate) of the pivot field
0x000A	itmtypeSTDEVP	Statistical standard deviation (entire population) of the pivot field
0x000B	itmtypeVAR	Statistical variance (estimate) of the pivot field
0x000C	itmtypeVARP	Statistical variance (entire population) of the pivot field

A - fHidden (1 bit):  A bit that specifies whether this pivot item is hidden. For more information, see Manual Filtering.

MUST be zero if itmType is not itmtypeData. MUST be zero for OLAP PivotTable view.

B - fHideDetail (1 bit):  A bit that specifies whether the pivot item detail is collapsed.

MUST be zero for OLAP PivotTable view.

C - reserved1 (1 bit): MUST be zero, and MUST be ignored.

D - fFormula (1 bit):  A bit that specifies whether this pivot item is a calculated item.

This field MUST be zero if any of the following apply:

• itmType is not zero.

• This item is in an OLAP PivotTable view.

• The sxaxisPage field of sxaxis in the Sxvd record of the pivot field equals 1 (the associated Sxvd is the last Sxvd record before this record in the stream).

• The fCalculatedField field in the SXVDEx record of the pivot field equals 1.

• There is not an associated SXFDB record in the associated PivotCache.

• The fRangeGroup field of the SXFDB record, of the associated cache field of the pivot field, equals 1.

• The fCalculatedField field of the SXFDB record, of the associated cache field of the pivot field, equals 1.

E - fMissing (1 bit):  A bit that specifies if this pivot item does not exist in the data source.

MUST be zero if itmType is not zero. MUST be zero for OLAP PivotTable view.

reserved2 (11 bits): MUST be zero, and MUST be ignored.

iCache (2 bytes):  A signed integer that specifies a reference to a cache item. MUST be a value from the following table:

Value	Meaning
-1	No cache item is referenced.
0+	A cache item index in the cache field associated with the pivot field, as specified by Cache Items.

If itmType is not zero, a reference to a cache item is not specified and this value MUST be -1. Otherwise, this value MUST be greater than or equal to 0.

cchName (2 bytes):  An unsigned integer that specifies the length of the stName string. If the value is 0xFFFF then stName is NULL. Otherwise, the value MUST be less than or equal to 254.

stName (variable):  An XLUnicodeStringNoCch structure that specifies the name of this pivot item. If not NULL, this is used as the caption of the pivot item instead of the value in the cache item specified by iCache. The length of this field is specified in cchName. This field exists only if cchName is not 0xFFFF. If this is in a non-OLAP PivotTable view and this string is not NULL, it MUST be unique within all SXVI records in associated with the pivot field.