ItemValues enumeration

Office 2013 and later

PivotItem Type

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

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

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: