Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Pivot Grid > Data Shaping > Sorting > Displaying Top N Values for a Field
All docs
V24.2
WinForms Controls
.NET Support and Migration
Prerequisites
What's New
What's Installed
Build an Application
Redistribution and Deployment
Controls and Libraries
Forms and User Controls
Messages, Notifications, and Dialogs
Editors and Simple Controls
Ribbon, Bars and Menu
Application UI Manager
Docking Library
Data Grid
Vertical Grid
Property Grid
Pivot Grid
Getting Started
Fundamentals
Binding to Data
Asynchronous Mode
Data Shaping
Summarization
Grouping
Sorting
Sorting Data
Displaying Top N Values for a Field
Sorting by Summary
Filtering
Pinned (Fixed) Columns
Editing
Data Formatting
Data Analysis
Layout
Focus and Navigation
Printing and Exporting
Appearance
Design-Time Features
Miscellaneous
UI Elements
End-User Capabilities
Examples
Tree List
Gantt Control
Chart Control
Diagrams
Gauges
Map Control
Scheduler
Spreadsheet
Rich Text Editor
Spell Checker
Form Layout Managers
Navigation Controls
Printing-Exporting
PDF Viewer
Reporting
Office File API
Snap
TreeMap Control
Sunburst Control
Sankey Diagram Control
Heatmap Control
Icon and Image Library
AI-powered Extensions
Common Features
Security Considerations
Data Access Security
Hybrid & Enterprise Development
UI Templates
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

Displaying Top N Values for a Field

  • 2 minutes to read

At times, end-users do not wish to browse an entire report and only need to see the best or worst results. For this purpose, Pivot Grid provides the Top N Values feature that can be used to limit the number of field values displayed to the specified number of topmost values according to the sort order.

Tip

Demo: Code Examples - Sorting - Top N module in the XtraPivotGrid MainDemo

Requires installation of WinForms Subscription. Download.

To enable this feature, use the PivotGridFieldBase.TopValueCount property. This property allows you to restrict the number of field values that are displayed along the column or row axis.

cdTopNValues

By default, the PivotGridFieldBase.TopValueCount property determines the absolute number of field values to display. You can also use this property to specify the number of displayed field values as a percentage ratio. Note that in this instance you should set the PivotGridFieldBase.TopValueType property to PivotTopValueType.Percent.

The meaning of this percentage ratio depends on the current data binding mode as follows.

  • In regular data binding mode, the PivotGridFieldBase.TopValueCount property value defines the percentage of displayed field values among all field values. For instance, if the PivotGridFieldBase.TopValueCount property is set to 50, Pivot Grid Control will display the first half of field values in the current field.
  • In an OLAP mode, Pivot Grid Control will display top values, whose cumulative total is equal to or greater than a specified percentage. For instance, if the PivotGridFieldBase.TopValueCount property is set to 50, Pivot Grid Control will display values whose cumulative total is not less than a half of the Grand Total value.

If the Top N Values feature is enabled, Pivot Grid Control displays the first field values according to the current sort order. The other values are hidden and are not used to calculate totals. Nevertheless, you can display this information by setting the sorted field’s PivotGridFieldBase.TopValueShowOthers property to true. The remaining (hidden) values are combined into a single item (“Others”) as a result.

cdTopNOtherValues

Note

In an OLAP mode, totals are calculated against all values even if the Top N Values feature is enabled.

See Also