• Material 3
  • Fluent
  • Fluent 2
  • Bootstrap 5
  • Tailwind CSS
  • High Contrast
  • Fluent 2 High Contrast
Preferences
Mode Selection
Touch
Mouse
Theme Selection
Theme Mode
Localization
*Translated by Google Translator.
Currency

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.

DEMO
SOURCE
Start Date: End Date:

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 .

Transform your ASP.NET Core web apps today with Syncfusion® ASP.NET Core components
100+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE
opens in a new tab