Table of Contents

Class ExcelPivotTableDataFieldShowDataAs

Namespace
OfficeOpenXml.Table.PivotTable
Assembly
EPPlus.dll

Represents a pivot fields Show As properties.

public class ExcelPivotTableDataFieldShowDataAs
Inheritance
ExcelPivotTableDataFieldShowDataAs
Inherited Members

Properties

Value

The value of the "Show Data As" setting

public eShowDataAs Value { get; }

Property Value

eShowDataAs

Methods

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

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

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, 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

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

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, 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

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

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