Example of External Filtering in ASP.NET Core Pivot Table Control
This sample demonstrates how to apply an external date range filter to the Pivot Table data source, enhancing performance and responsiveness when working with large datasets.
In this sample, date filtering is performed externally by updating the Pivot Table's data source based on a selected date range. Users can choose a Start Date and End Date using date pickers, and the table updates to show only the records that fall within that range.
This external filtering method improves performance by avoiding in-component filtering. Instead, the data is
pre-filtered at runtime using a custom applyDateFilter
function, which compares the selected date
range with each record's date in the original dataset. This reduces the processing load on the Pivot Table and
results in a more responsive user experience.
Note: Aggregation in the Pivot Table is performed only on the filtered data. Any records outside the selected date range are excluded from the summary calculations.
More information on the ASP.NET Core Pivot Table can be found in this documentation section .