TcxPivotGridField.TopValueShowOthers Property

Specifies whether the ‘Others’ item is displayed in the pivot grid when the Top N Values feature is enabled.

Declaration

property TopValueShowOthers: Boolean read; write; default False;

Property Value

Type	Default
Boolean	False

Remarks

Setting the TopValueCount property to a positive value enables the Top X Value feature. In this instance, the ExpressPivotGrid displays the specified number of field values of the current column field or row field, according to the current sort order. The other field values are hidden and are not used to calculate totals.

If the TopValueShowOthers property is set to False, the field values that follow the top values are hidden and are not used to calculate totals. If this property is set to True, the remaining values will be combined into a single item (‘Others’). Set the scxOthers resource string to specify the caption of this item.

Note

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

The default value of the TopValueShowOthers property is False.