2.4.278 SXDI

The SXDI record specifies a data item for 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

isxvdData

iiftab

df

isxvd

isxvi

ifmt

cchName

stName (variable)

...

isxvdData (2 bytes):  A signed integer that specifies a pivot field index as specified in Pivot Fields.

If the PivotTable view is a non-OLAP PivotTable view, the values in the source data associated with the associated cache field of the referenced pivot field are aggregated as specified in this record.

If the PivotTable view is an OLAP PivotTable view, the associated pivot hierarchy of the referenced pivot field specifies the OLAP measure for this data item and the iiftab field is ignored. See Association of Pivot Hierarchies and Pivot Fields and Cache Fields to determine the associated pivot hierarchy.

MUST be greater than or equal to zero and less than the value of the cDim field of the preceding SxView record.

The value of the sxaxis.sxaxisData field of the Sxvd record of the referenced pivot field MUST be 1.

iiftab (2 bytes):  A signed integer that specifies the aggregation function.

MUST be a value from the following table:

Value

Meaning

0x0000

Sum of values

0x0001

Count of values

0x0002

Average of values

0x0003

Max of values

0x0004

Min of values

0x0005

Product of values

0x0006

Count of numbers

0x0007

Statistical standard deviation (sample)

0x0008

Statistical standard deviation (population)

0x0009

Statistical variance (sample)

0x000A

Statistical variance (population)

df (2 bytes):  A signed integer that specifies the calculation used to display the value of this data item.

MUST be a value from the following table:

Value

Meaning

0x0000

The data item value is displayed.

0x0001

Display as the difference between this data item value and the value of the pivot item specified by isxvi.

0x0002

Display as a percentage of the value of the pivot item specified by isxvi.

0x0003

Display as a percentage difference from the value of the pivot item specified by isxvi.

0x0004

Display as the running total for successive pivot items in the pivot field specified by isxvd.

0x0005

Display as a percentage of the total for the row containing this data item.

0x0006

Display as a percentage of the total for the column containing this data item.

0x0007

Display as a percentage of the grand total of the data item.

0x0008

Calculate the value to display using the following formula:

((this data item value) * (grand total of grand totals)) / ((row grand total) * (column grand total))

isxvd (2 bytes):  A signed integer that specifies a pivot field index as specified in Pivot Fields. The referenced pivot field is used in calculations as specified by the df field.

If df is 0x0001, 0x0002, 0x0003, or 0x0004 then the value of isxvd MUST be greater than or equal to zero and less than the value of the cDim field in the preceding SxView record. Otherwise, the value of isxvd is undefined and MUST be ignored.

isxvi (2 bytes):  A signed integer that specifies the pivot item used by df.

If df is 0x0001, 0x0002, or 0x0003 then the value of this field MUST be a value from the following table:

Value

Meaning

0 to 0x7EFE

A pivot item index, as specified by Pivot Items, that specifies a pivot item in the pivot field specified by isxvd. MUST be less than the cItm field of the Sxvd record of the pivot field specified by isxvd.

0x7FFB

The previous pivot item in the pivot field specified by isxvd.

0x7FFC

The next pivot item in the pivot field specified by isxvd.

Otherwise, the value is undefined and MUST be ignored.

ifmt (2 bytes):  An IFmt structure that specifies the number format for this item.

cchName (2 bytes):  An unsigned integer that specifies the length, in characters, of the XLUnicodeStringNoCch structure in the stName field. If the value is 0xFFFF then stName does not exist. Otherwise, the value MUST be greater than zero and less than or equal to 0x00FF.

MUST NOT be 0xFFFF when the PivotCache functionality level is less than 3, or for non-OLAP PivotTable view .

stName (variable):  An XLUnicodeStringNoCch structure that specifies the name of this data item. A value that is not NULL specifies that this string is used to override the name in the corresponding cache field.

MUST NOT exist if cchName is 0xFFFF. Otherwise, MUST exist and the length MUST equal cchName.

If this string is not NULL and the PivotTable view is a non-OLAP PivotTable view, this field MUST be unique within all SXDI records in this PivotTable view.