.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

PivotShowValuesAsType Enum

Lists options that specify how summary values are displayed within a data field.

Namespace: DevExpress.Spreadsheet

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

Declaration

public enum PivotShowValuesAsType
Public Enum PivotShowValuesAsType
public enum PivotShowValuesAsType
Public Enum PivotShowValuesAsType
public enum PivotShowValuesAsType
Public Enum PivotShowValuesAsType

Members

Name Description
Difference

Displays values in a data field as the difference from the value of the PivotDataField.BaseItem in the PivotDataField.BaseField.

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))

NoCalculation

Displays summary values for a data field "as-is", with no additional calculation applied.

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.

PercentOfColumn

Displays values in each column as the percentage of the total value of the column.

PercentOfParent

Displays values in a data field as the percentage of the value of the parent item of the specified PivotDataField.BaseField.

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.

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.

PercentOfRow

Displays values in each row as the percentage of the total value of the row.

PercentOfRunningTotal

Calculates a running total for successive items in the PivotDataField.BaseField as a percentage of the grand total value.

PercentOfTotal

Displays values as the percentage of the grand total of all values in the PivotTable report.

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.

RunningTotal

Displays values for successive items in the PivotDataField.BaseField as a running total.

Remarks

The PivotShowValuesAsType enumeration member is passed to the PivotDataField.ShowValuesWithCalculation method as a parameter. Subsequently, it is the value of the PivotDataField.ShowValuesAs property.

See Also