PivotGridCustomSummaryEventArgsBase<T>.CreateDrillDownDataSource() Method

Returns data records associated with the current cell.

Namespace: DevExpress.XtraPivotGrid.Data

Assembly: DevExpress.PivotGrid.v19.1.Core.dll

Declaration

C#

public PivotDrillDownDataSource CreateDrillDownDataSource()

VB.NET

Public Function CreateDrillDownDataSource As PivotDrillDownDataSource

Returns

Type	Description
PivotDrillDownDataSource	A PivotDrillDownDataSource object that contains the records associated with the current cell.

Remarks

The CreateDrillDownDataSource method retrieves data source records used to calculate current cell values.

The Pivot Grid control cells display summary and total summary values. Column and row headers display values used as criteria applied to the underlying data source to obtain a set of data records for summary calculation.

Consider the Pivot Grid control in the following image.

The value in the top-leftmost cell ($1,422.00) is calculated using the ‘Product Sales’ field for a set of records that satisfy the following criteria:

• the ‘Category Name’ field has the value ‘Beverages’
• the ‘Product Name’ field has the value ‘Chai’
• the ‘Shipped Year’ field has the value 2014

The value at the intersection of the first column and third row ($4,154.96) is calculated for the records that satisfy the following criteria:

• the ‘Category Name’ field has the value ‘Beverages’
• the ‘Shipped Year’ field has the value 2014