Class ExcelPivotTableCalculatedData

Represents a selection of a row or column field to retreive the calculated value from a pivot table.

public class ExcelPivotTableCalculatedData

Inherited Members: object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Methods

public object GetValue(int dataFieldIndex = 0)

dataFieldIndex int: The index for the date field in the DataFields collection

object: The value from the pivot table. If data field does not exist of the selected fields does not match any part of the pivot table a #REF! error is retuned.

public object GetValue(string dataFieldName)

Specifies which value to use for a field.

public ExcelPivotTableCalculatedData SelectField(string fieldName, object value)

ExcelPivotTableCalculatedData: A new ExcelPivotTableCalculatedData to select other row or column field values or fetch the calulated value in a fluent way.

Specifies which value to use for a field.

public ExcelPivotTableCalculatedData SelectField(string fieldName, object value, eSubTotalFunctions subtotalFunction)