2.4.278 SXDI
The SXDI record specifies a data item for a PivotTable view.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.