Class ExcelPivotTableDataFieldShowDataAs¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

Represents a pivot fields Show As properties.

public class ExcelPivotTableDataFieldShowDataAs

Inheritance¶

object ← ExcelPivotTableDataFieldShowDataAs

Inherited Members¶

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

Properties¶

Value¶

The value of the "Show Data As" setting

public eShowDataAs Value { get; }

Property Value¶

eShowDataAs

Methods¶

SetDifference(ExcelPivotTableField, int)¶

Sets the show data as to type Difference

public void SetDifference(ExcelPivotTableField baseField, int baseItem)

Parameters¶

baseField ExcelPivotTableField

The base field to use

baseItem int

The index of the item to use within the Items collection of the base field

SetDifference(ExcelPivotTableField, ePrevNextPivotItem)¶

Sets the show data as to type Difference

public void SetDifference(ExcelPivotTableField baseField, ePrevNextPivotItem baseItem)

Parameters¶

baseField ExcelPivotTableField

The base field to use

baseItem ePrevNextPivotItem

The previous or next field

SetIndex()¶

Sets the show data as to type Index

public void SetIndex()

SetNormal()¶

Sets the show data as to type Normal. This removes the Show data as setting.

public void SetNormal()

SetPercent(ExcelPivotTableField, int)¶

Sets the show data as to type Percent The base field to use The index of the item to use within the Items collection of the base field

public void SetPercent(ExcelPivotTableField baseField, int baseItem)

Parameters¶

baseField ExcelPivotTableField

baseItem int

SetPercent(ExcelPivotTableField, ePrevNextPivotItem)¶

Sets the show data as to type Percent The base field to use The previous or next field

public void SetPercent(ExcelPivotTableField baseField, ePrevNextPivotItem baseItem)

Parameters¶

baseField ExcelPivotTableField

baseItem ePrevNextPivotItem

SetPercentOfColumn()¶

Sets the show data as to type Percent Of Column

public void SetPercentOfColumn()

SetPercentOfRow()¶

Sets the show data as to type Percent Of Row

public void SetPercentOfRow()

SetPercentOfRunningTotal(ExcelPivotTableField)¶

Sets the show data as to type Percent Of Running Total

public void SetPercentOfRunningTotal(ExcelPivotTableField baseField)

Parameters¶

baseField ExcelPivotTableField

SetPercentOfTotal()¶

Sets the show data as to type Percent Of Total

public void SetPercentOfTotal()

SetPercentParent(ExcelPivotTableField)¶

Sets the show data as to type Percent Of Parent The base field to use

public void SetPercentParent(ExcelPivotTableField baseField)

Parameters¶

baseField ExcelPivotTableField

SetPercentParentColumn()¶

Sets the show data as to type Percent Of Parent Column

public void SetPercentParentColumn()

SetPercentParentRow()¶

Sets the show data as to type Percent Of Parent Row

public void SetPercentParentRow()

SetPercentageDifference(ExcelPivotTableField, int)¶

Sets the show data as to type Percent Of Total The base field to use The index of the item to use within the Items collection of the base field

public void SetPercentageDifference(ExcelPivotTableField baseField, int baseItem)

Parameters¶

baseField ExcelPivotTableField

baseItem int

SetPercentageDifference(ExcelPivotTableField, ePrevNextPivotItem)¶

Sets the show data as to type Percent Of Total The base field to use The previous or next field

public void SetPercentageDifference(ExcelPivotTableField baseField, ePrevNextPivotItem baseItem)

Parameters¶

baseField ExcelPivotTableField

baseItem ePrevNextPivotItem

SetRankAscending(ExcelPivotTableField)¶

Sets the show data as to type Rank Ascending The base field to use

public void SetRankAscending(ExcelPivotTableField baseField)

Parameters¶

baseField ExcelPivotTableField

SetRankDescending(ExcelPivotTableField)¶

Sets the show data as to type Rank Descending The base field to use

public void SetRankDescending(ExcelPivotTableField baseField)

Parameters¶

baseField ExcelPivotTableField

SetRunningTotal(ExcelPivotTableField)¶

Sets the show data as to type Running Total

public void SetRunningTotal(ExcelPivotTableField baseField)

Parameters¶

baseField ExcelPivotTableField

The base field to use