All Demos / Pivot Table / Filtering / External Filtering

Blazor Pivot Table Example - External Filtering

Loading Syncfusion Blazor Server Demos…
This demo passes automated axe checks with 0 violations — semantic markup, ARIA, full keyboard operation, visible focus. Section 508 conformant Accessibility report VPAT

This sample demonstrates applying external date range filters to Pivot Table data source for enhanced performance with large datasets.

Date filtering features:

  • Users select start and end dates via date pickers
  • Table updates to show records within selected range
  • Pre-filters data at runtime using custom function
  • Improves performance by avoiding in-component filtering

The external filtering method:

  • Compares selected date range with record dates
  • Reduces processing load on Pivot Table
  • Results in more responsive user experience

Note: Aggregation is performed only on filtered data. Records outside selected range are excluded from calculations.