Enum eShowDataAs¶
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
The data formats for a field in the PivotTable
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.
PercentOfRow = 6
The field is shown as the percentage of the row
PercentOfTotal = 7
The field is shown as the percentage of the total
RunningTotal = 8
The field is shown as the running total in the the table
PercentOfParentRow = 9
The field is shown as the percentage of the parent row total
PercentOfParentColumn = 10
The field is shown as the percentage of the parent column total
PercentOfParent = 11
The field is shown as the percentage of the parent 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.
PercentOfRunningTotal = 14
The field is shown as the percentage of the running total