2.4.312 SXVI

  • Article

The SXVI record specifies information about a pivot item.


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

itmType

A

B

C

D

E

reserved2

iCache

cchName

stName (variable)

...

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.