Table of Contents

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

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