FieldTopValueType Enum

Lists the values that specify how the number of Top Values is determined.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v14.2.dll

Declaration

C#

public enum FieldTopValueType

VB.NET

Public Enum FieldTopValueType

Members

Name	Description
Absolute	The PivotGridField.TopValueCount property determines the absolute number of top field values to display. For instance, if there are 20 unique field values and the TopValueCount property is set to 10, only the 10 top field values will be displayed.
Percent	In a regular data binding mode, the PivotGridField.TopValueCount property determines the number of field values to display relative to the total number of field values. For instance, if there are 20 unique field values and the PivotGridField.TopValueCount property is set to 10, only 2 top field values (10% out of 20) will be displayed. In an OLAP mode, PivotGridControl will display top values whose cumulative total is equal to or greater than a specified percentage. For instance, if the PivotGridField.TopValueCount property is set to 10, PivotGridControl will display values whose cumulative total is not less than 10% of the Grand Total value.
Sum	The PivotGridField.TopValueCount property determines the maximum allowed sum of the corresponding summary values. For instance, if the PivotGridField.TopValueCount property is set to 100, the PivotGridControl will display field values whose corresponding summaries do not exceed 100. Works in OLAP mode only.

Passed To

You can pass FieldTopValueType values to the PivotGridField.TopValueType property.

Remarks

The values listed by this enumeration are used to set the PivotGridField.TopValueType property.