This documentation is archived and is not being maintained.

ItemValues Enumeration

PivotItem Type

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public enum ItemValues

Member nameDescription
Data Data. When the item is serialized out as xml, its value is "data".
Default Default. When the item is serialized out as xml, its value is "default".
Sum Sum. When the item is serialized out as xml, its value is "sum".
CountA CountA. When the item is serialized out as xml, its value is "countA".
Average Average. When the item is serialized out as xml, its value is "avg".
Maximum Max. When the item is serialized out as xml, its value is "max".
Minimum Min. When the item is serialized out as xml, its value is "min".
Product Product. When the item is serialized out as xml, its value is "product".
Count Count. When the item is serialized out as xml, its value is "count".
StandardDeviation stdDev. When the item is serialized out as xml, its value is "stdDev".
StandardDeviationP StdDevP. When the item is serialized out as xml, its value is "stdDevP".
Variance Var. When the item is serialized out as xml, its value is "var".
VarianceP VarP. When the item is serialized out as xml, its value is "varP".
Grand Grand Total Item. When the item is serialized out as xml, its value is "grand".
Blank Blank Pivot Item. When the item is serialized out as xml, its value is "blank".
Show: