Show / Hide Table of Contents

Class PivotDataFieldItemSelection

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

Inheritance
System.Object
PivotDataFieldItemSelection
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.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
System.String fieldName

The row/column field to filter

System.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
System.String fieldName

The row/column field to filter

System.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
System.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
System.Object
In This Article
Back to top Generated by DocFX