Class ExcelPivotTableDataFieldShowDataAs

Represents a pivot fields Show As properties.

Inheritance

System.Object

ExcelPivotTableDataFieldShowDataAs

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

Assembly: EPPlus.dll

Syntax

public class ExcelPivotTableDataFieldShowDataAs

Properties

Value

The value of the "Show Data As" setting

Declaration

public eShowDataAs Value { get; }

Property Value

Type	Description
eShowDataAs

Methods

SetDifference(ExcelPivotTableField, ePrevNextPivotItem)

Sets the show data as to type Difference

Declaration

public void SetDifference(ExcelPivotTableField baseField, ePrevNextPivotItem baseItem)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField	The base field to use
ePrevNextPivotItem	baseItem	The previous or next field

SetDifference(ExcelPivotTableField, Int32)

Sets the show data as to type Difference

Declaration

public void SetDifference(ExcelPivotTableField baseField, int baseItem)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField	The base field to use
System.Int32	baseItem	The index of the item to use within the Items collection of the base field

SetIndex()

Sets the show data as to type Index

Declaration

public void SetIndex()

SetNormal()

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

Declaration

public void SetNormal()

SetPercent(ExcelPivotTableField, ePrevNextPivotItem)

Sets the show data as to type Percent

The base field to use The previous or next field

Declaration

public void SetPercent(ExcelPivotTableField baseField, ePrevNextPivotItem baseItem)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField
ePrevNextPivotItem	baseItem

SetPercent(ExcelPivotTableField, Int32)

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

Declaration

public void SetPercent(ExcelPivotTableField baseField, int baseItem)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField
System.Int32	baseItem

SetPercentageDifference(ExcelPivotTableField, ePrevNextPivotItem)

Sets the show data as to type Percent Of Total

The base field to use The previous or next field

Declaration

public void SetPercentageDifference(ExcelPivotTableField baseField, ePrevNextPivotItem baseItem)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField
ePrevNextPivotItem	baseItem

SetPercentageDifference(ExcelPivotTableField, Int32)

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

Declaration

public void SetPercentageDifference(ExcelPivotTableField baseField, int baseItem)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField
System.Int32	baseItem

SetPercentOfColumn()

Sets the show data as to type Percent Of Column

Declaration

public void SetPercentOfColumn()

SetPercentOfRow()

Sets the show data as to type Percent Of Row

Declaration

public void SetPercentOfRow()

SetPercentOfRunningTotal(ExcelPivotTableField)

Sets the show data as to type Percent Of Running Total

Declaration

public void SetPercentOfRunningTotal(ExcelPivotTableField baseField)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField

SetPercentOfTotal()

Sets the show data as to type Percent Of Total

Declaration

public void SetPercentOfTotal()

SetPercentParent(ExcelPivotTableField)

Sets the show data as to type Percent Of Parent

The base field to use

Declaration

public void SetPercentParent(ExcelPivotTableField baseField)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField

SetPercentParentColumn()

Sets the show data as to type Percent Of Parent Column

Declaration

public void SetPercentParentColumn()

SetPercentParentRow()

Sets the show data as to type Percent Of Parent Row

Declaration

public void SetPercentParentRow()

SetRankAscending(ExcelPivotTableField)

Sets the show data as to type Rank Ascending

The base field to use

Declaration

public void SetRankAscending(ExcelPivotTableField baseField)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField

SetRankDescending(ExcelPivotTableField)

Sets the show data as to type Rank Descending

The base field to use

Declaration

public void SetRankDescending(ExcelPivotTableField baseField)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField

SetRunningTotal(ExcelPivotTableField)

Sets the show data as to type Running Total

Declaration

public void SetRunningTotal(ExcelPivotTableField baseField)

Parameters

Type	Name	Description
ExcelPivotTableField	baseField	The base field to use