Class PivotDataFieldItemSelection

An Item selection for a row or colummn field used as argument to the GetPivotData method to filter.

Inheritance

object

PivotDataFieldItemSelection

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Table.PivotTable.Calculation

Assembly: EPPlus.dll

Syntax

public class PivotDataFieldItemSelection

Constructors

PivotDataFieldItemSelection(string, object)

Constructor

Declaration

public PivotDataFieldItemSelection(string fieldName, object value)

Parameters

Type	Name	Description
string	fieldName	The row/column field to filter
object	value	The value to filter on

PivotDataFieldItemSelection(string, object, eSubTotalFunctions)

Constructor

Declaration

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

Parameters

Type	Name	Description
string	fieldName	The row/column field to filter
object	value	The value to filter on
eSubTotalFunctions	subtotalFunction	If a row/column field has one or multiple Subtotal Functions specified, you can access them here.

Properties

FieldName

The row or column field.

Declaration

public string FieldName { get; set; }

Property Value

Type	Description
string

SubtotalFunction

If a row/column field has a subtotal subtotalFunction other that "Default" or "None", it can be specified in the criteria.

Declaration

public eSubTotalFunctions SubtotalFunction { get; set; }

Property Value

Type	Description
eSubTotalFunctions

Value

The value to filter on.

Declaration

public object Value { get; set; }

Property Value

Type	Description
object