Obtaining Underlying Data
Pivot Grid converts lengthy table data into compact reports that display summarized data. Cells display summaries calculated against data field(s) for a subset of the records in the pivot grid's data source. All records from this subset have matching values in a column field(s) and row field(s). These values are identified by column and row headers.
To get the list of data source records for an individual cell, use the PivotGridControl.CreateDrillDownDataSource method.
#Example: How to Obtain Underlying Data
The PivotGridControl supports the drill-down capability, which enables you to retrieve a list of records that can be used to calculate a particular summary. To obtain drill-down data, use the PivotGridControl's PivotCellBaseEventArgs.CreateDrillDownDataSource method. Its parameters completely identify a summary cell.
In this example, an end-user can view records from the control's underlying data source, associated with a summary cell, by double-clicking it. The obtained data is displayed by the DXGrid within a popup window.