Support for the 'Add Current Selection to Filter' feature in Pivot Table Validated

Filtering allows you to view the Pivot Table with selected records based on members that can be included or excluded through the UI or code-behind. However, we currently do not support the “Add Current Selection to Filter” feature, which is available in Microsoft Excel Pivot Tables.

In Excel, this feature enables users to add new items to an existing filter without removing previously selected ones. For example, if a field contains countries like France, Germany, and Canada, and you initially filter by France, you can later add Germany to the filter so that both France and Germany are included.

In our Syncfusion Pivot Table, this functionality is not yet available. If you apply a filter for Germany after selecting France, the previous selection is cleared, and only Germany’s data is displayed. To avoid this behavior, we need to implement the “Add Current Selection to Filter” feature similar to Excel Pivot Tables. Please refer to the image below for a visual demonstration.