TcxPivotGridField.TopValueCount Property

Specifies the total number of the field values that are to be displayed for the current column field or row field.

Declaration

property TopValueCount: Integer read; write; default 0;

Property Value

Type	Default
Integer	0

Remarks

The ExpressPivotGrid provides the Top N Values feature that allows you to display the first top field values (which are the most significant in most cases) while ignoring the rest values. To enable this feature, the TopValueCount property should be set to a positive value. This value determines the number of top field values to display, according to the current sort order. For instance, if there are twenty unique field values and the TopValueCount property is set to 10, only the top ten field values will be displayed.

To display an aggregate value for the field values that are hidden in a Top N Values report, set the TopValueShowOthers property to True. The remaining (hidden) values are combined into a single item (‘Others’), as a result. Set the scxOthers resource string to specify the caption of this item.

Note

The TopValueCount property is in effect only in standard data binding modes.

The default value of the TopValueCount property is 0.