Displaying Top N Values for a Field
Sometimes end-users are not interested in browsing the entire report but only need to see the best or worst results. For this purpose, the ExpressPivotGrid provides the Top N Values feature which can be used to suppress surplus information and limit the number of field values displayed, to the specified number of topmost values according to the sort order.
To enable this feature, use a field’s TopValueCount property. This property allows you to restrict the number of field values that are displayed in the column or row area.
If the Top N Values feature is enabled, the pivot grid displays the first N field values according to the current sort order. The other values are hidden and are not used to calculate totals. You can, however, display this information by setting the sorted field’s TopValueShowOthers property to True. The remaining (hidden) values are combined into a single item (‘Others’), as a result.
