PivotShowValuesAsType Enum
Lists options that specify how summary values are displayed within a data field.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
#Members
Name | Description |
---|---|
No
|
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 Pivot |
Percent
|
Displays values in a data field as the percentage of the value of the Pivot |
Percent
|
Displays values in a data field as the percentage difference from the value of the Pivot |
Running
|
Displays values for successive items in the Pivot |
Percent
|
Displays values in each row as the percentage of the total value of the row. |
Percent
|
Displays values in each column as the percentage of the total value of the column. |
Percent
|
Displays values as the percentage of the grand total of all values in the Pivot |
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)) |
Rank
|
Displays the rank of values for a specific Pivot |
Rank
|
Displays the rank of values for a specific Pivot |
Percent
|
Calculates a running total for successive items in the Pivot |
Percent
|
Displays values in a data field as the percentage of the value of the parent item of the specified Pivot |
Percent
|
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. |
Percent
|
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. |
#Related API Members
The following properties accept/return PivotShowValuesAsType values:
#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.