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
Methods
SetDifference(ExcelPivotTableField, ePrevNextPivotItem)
Sets the show data as to type Difference
public void SetDifference(ExcelPivotTableField baseField, ePrevNextPivotItem baseItem)
Parameters
baseField
ExcelPivotTableFieldThe base field to use
baseItem
ePrevNextPivotItemThe previous or next field
SetDifference(ExcelPivotTableField, int)
Sets the show data as to type Difference
public void SetDifference(ExcelPivotTableField baseField, int baseItem)
Parameters
baseField
ExcelPivotTableFieldThe base field to use
baseItem
intThe 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 fieldpublic void SetPercent(ExcelPivotTableField baseField, ePrevNextPivotItem baseItem)
Parameters
baseField
ExcelPivotTableFieldbaseItem
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 fieldpublic void SetPercent(ExcelPivotTableField baseField, int baseItem)
Parameters
baseField
ExcelPivotTableFieldbaseItem
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 usepublic 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 fieldpublic void SetPercentageDifference(ExcelPivotTableField baseField, ePrevNextPivotItem baseItem)
Parameters
baseField
ExcelPivotTableFieldbaseItem
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 fieldpublic void SetPercentageDifference(ExcelPivotTableField baseField, int baseItem)
Parameters
baseField
ExcelPivotTableFieldbaseItem
int
SetRankAscending(ExcelPivotTableField)
Sets the show data as to type Rank Ascending
The base field to usepublic void SetRankAscending(ExcelPivotTableField baseField)
Parameters
baseField
ExcelPivotTableField
SetRankDescending(ExcelPivotTableField)
Sets the show data as to type Rank Descending
The base field to usepublic 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
ExcelPivotTableFieldThe base field to use