Enum eShowDataAs

The data formats for a field in the PivotTable

public enum eShowDataAs

Name	Description
Difference	The field is shown as the "difference from" a value.
Index	The field is shown as the index. ((Cell Value) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))
Normal	The field is shown as its normal datatype.
Percent	The field is show as the percentage of a value
PercentDifference	The field is shown as the percentage difference from a value.
PercentOfColumn	The field is shown as the percentage of the column.
PercentOfParent	The field is shown as the percentage of the parent total
PercentOfParentColumn	The field is shown as the percentage of the parent column total
PercentOfParentRow	The field is shown as the percentage of the parent row total
PercentOfRow	The field is shown as the percentage of the row
PercentOfRunningTotal	The field is shown as the percentage of the running total
PercentOfTotal	The field is shown as the percentage of the total
RankAscending	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	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	The field is shown as the running total in the the table