PivotDataGrid LoadData

The LoadData event allows you to perform custom paging, sorting and filtering.

In this demo the pivot table uses LoadData event with Entity Framework for custom data loading, supporting paging, sorting, and filtering with the same Year/Country columns and Category/Product rows, calculating grand totals using GetAggregateValue method.