Skip to main content
BuyLog In
VCL
Search in…
Docs > VCL Controls > ExpressPivotGrid Suite > Feature Center > Data-Related Features > Group Values on Axes
All docs
V23.2
VCL Controls
ExpressQuantumGrid Suite
ExpressEditors Library
ExpressBars Suite
ExpressCharts Suite
Express Cross Platform Library
ExpressRichEditControl Suite
ExpressSkins Library
ExpressScheduler Suite
ExpressSpreadSheet Suite
ExpressQuantumTreeList Suite
ExpressPDFViewer Suite
ExpressPrinting System
ExpressLayoutControl Suite
ExpressNavBar Suite
ExpressPivotGrid Suite
Concepts
Fundamentals
Feature Center
Feature Center
Data Exchange
Layout Features
Data-Related Features
Data-Related Features (Overview)
Data Cell Content
Filter Data
Format Cells and Values
Get Underlying Data
Group Values on Axes
Sort Data and Display Top N Values
Totals and Grand Totals
Focus and Navigation
Appearance
Miscellaneous
Visual Elements
Design-Time Features
End-User Capabilities
Member Tables
Task-Based Help
API Reference
ExpressVerticalGrid Suite
ExpressDocking Library
ExpressMemData
ExpressDataController
ExpressSpellChecker Suite
ExpressMapControl Suite
ExpressGanttControl Suite
ExpressGaugeControl Suite
ExpressTileControl Suite
ExpressFlowChart Suite
ExpressFlowChart Editor
ExpressOrgChart Suite
ExpressPageControl Suite
ExpressWizardControl Suite

Group Values on Axes

The ExpressPivotGrid control provides a grouping feature - specific field values can be automatically grouped into bigger categories (ranges) which are represented by columns and rows – the axes of the report. The grouping feature is especially useful for representing date-time and numeric data. For instance, the values of a column or row field which displays date-time data can be grouped by years, months, quarters, etc. Unique numeric values can be grouped into numeric ranges. String values can be grouped by the starting characters of the values.

Concepts

Grouping Values

Member Table

Member Table: Group Values on Axes

Task-Based Help

How to Provide Custom Grouping Values

See Also