Class PivotDataFieldItemSelection
- Namespace
- OfficeOpenXml.Table.PivotTable.Calculation
- Assembly
- EPPlus.dll
An Item selection for a row or colummn field used as argument to the GetPivotData method to filter.
public class PivotDataFieldItemSelection
- Inheritance
-
PivotDataFieldItemSelection
- Inherited Members
Constructors
PivotDataFieldItemSelection(string, object)
Constructor
public PivotDataFieldItemSelection(string fieldName, object value)
Parameters
PivotDataFieldItemSelection(string, object, eSubTotalFunctions)
Constructor
public PivotDataFieldItemSelection(string fieldName, object value, eSubTotalFunctions subtotalFunction)
Parameters
fieldNamestringThe row/column field to filter
valueobjectThe value to filter on
subtotalFunctioneSubTotalFunctionsIf a row/column field has one or multiple Subtotal Functions specified, you can access them here.
Properties
FieldName
The row or column field.
public string FieldName { get; set; }
Property Value
SubtotalFunction
If a row/column field has a subtotal subtotalFunction other that "Default" or "None", it can be specified in the criteria.
public eSubTotalFunctions SubtotalFunction { get; set; }
Property Value
Value
The value to filter on.
public object Value { get; set; }