Enum eShowDataAs

Namespace

OfficeOpenXml.Table.PivotTable

Assembly

EPPlus.dll

The data formats for a field in the PivotTable

public enum eShowDataAs

Fields

Difference = 0

The field is shown as the "difference from" a value.

Index = 1

The field is shown as the index. ((Cell Value) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))

Normal = 2

The field is shown as its normal datatype.

Percent = 3

The field is show as the percentage of a value

PercentDifference = 4

The field is shown as the percentage difference from a value.

PercentOfColumn = 5

The field is shown as the percentage of the column.

PercentOfParent = 11

The field is shown as the percentage of the parent total

PercentOfParentColumn = 10

The field is shown as the percentage of the parent column total

PercentOfParentRow = 9

The field is shown as the percentage of the parent row total

PercentOfRow = 6

The field is shown as the percentage of the row

PercentOfRunningTotal = 14

The field is shown as the percentage of the running total

PercentOfTotal = 7

The field is shown as the percentage of the total

RankAscending = 12

The field is shown as the rank ascending. Lists the smallest item in the field as 1, and each larger value with a higher rank value.

RankDescending = 13

The field is shown as the rank descending. Lists the largest item in the field as 1, and each smaller value with a higher rank value.

RunningTotal = 8

The field is shown as the running total in the the table