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¶

object ← PivotDataFieldItemSelection

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

PivotDataFieldItemSelection(string, object)¶

Constructor

public PivotDataFieldItemSelection(string fieldName, object value)

Parameters¶

fieldName string

The row/column field to filter

value object

The value to filter on

PivotDataFieldItemSelection(string, object, eSubTotalFunctions)¶

Constructor

public PivotDataFieldItemSelection(string fieldName, object value, eSubTotalFunctions subtotalFunction)

Parameters¶

fieldName string

The row/column field to filter

value object

The value to filter on

subtotalFunction eSubTotalFunctions

If 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¶

string

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¶

eSubTotalFunctions

Value¶

The value to filter on.

public object Value { get; set; }

Property Value¶

object