PivotDataField.ShowValuesAs Property

Gets the type of calculation applied to the data field in addition to the actual value of the field.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

PivotShowValuesAsType ShowValuesAs { get; }

VB.NET

ReadOnly Property ShowValuesAs As PivotShowValuesAsType

Property Value

Type	Description
PivotShowValuesAsType	A PivotShowValuesAsType enumeration member specifying how summary values are displayed within the data field.

Available values:

Show 15 items

Name	Description
NoCalculation	Displays summary values for a data field “as-is”, with no additional calculation applied.
Difference	Displays values in a data field as the difference from the value of the PivotDataField.BaseItem in the PivotDataField.BaseField.
Percent	Displays values in a data field as the percentage of the value of the PivotDataField.BaseItem in the PivotDataField.BaseField.
PercentDifference	Displays values in a data field as the percentage difference from the value of the PivotDataField.BaseItem in the PivotDataField.BaseField.
RunningTotal	Displays values for successive items in the PivotDataField.BaseField as a running total.
PercentOfRow	Displays values in each row as the percentage of the total value of the row.
PercentOfColumn	Displays values in each column as the percentage of the total value of the column.
PercentOfTotal	Displays values as the percentage of the grand total of all values in the PivotTable report.
Index	Calculates the relative importance of each summary value by using the following formula: ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))
RankAscending	Displays the rank of values for a specific PivotDataField.BaseField, listing the smallest item in the field as 1, and each larger value with a higher rank value.
RankDescending	Displays the rank of values for a specific PivotDataField.BaseField, listing the largest item in the field as 1, and each smaller value with a higher rank value.
PercentOfRunningTotal	Calculates a running total for successive items in the PivotDataField.BaseField as a percentage of the grand total value.
PercentOfParent	Displays values in a data field as the percentage of the value of the parent item of the specified PivotDataField.BaseField.
PercentOfParentRow	Displays values in each inner row as the percentage of the total of the parent item in the outer row. The parent row for the item values of the outermost row field is the grand total row.
PercentOfParentColumn	Displays values in each inner column as the percentage of the total of the parent item in the outer column. The parent column for the item values of the outermost column field is the grand total column.