Get Underlying Data
- 2 minutes to read
A data cell displays a summary result calculated for a subset of records in the control’s underlying data source. All the records from this subset have matching values of column and row fields and these are identified by the corresponding column and row headers. To get the underlying records for a particular data cell, use the CreateDrillDownDataSource method of the cross cell which corresponds to this data cell.
Consider the following sample ExpressPivotGrid control:
In this example, for the cell (3) at the intersection of the second column and first row, the CreateDrillDownDataSource method will return the records from the data source which have:
the value ‘Christies House of Design’ in the ‘Company Name’ field;
the value ‘BMW: 530i’ in the ‘Car Name’ field;
the value ‘Cash’ in the ‘Payment Type’ field.
For the cell (16) at the intersection of the second column and seventh row, the CreateDrillDownDataSource method will return the records which have:
- the value ‘Cash’ in the ‘Payment Type’ field.
To cache a pivot grid’s drill-down data of data cells into an in-memory read-only dataset, use the TcxPivotGridDrillDownDataSet component.