Clearing Pivot Filters in Pivot Table

[Aakash Jethva]

I want to Clear Manual, Label and Value filters in pivot Table. Is this still possible?

I think the same question have been asked in ASP.NET WEB FORMS forum as well at below location:

https://www.syncfusion.com/forums/144315/clearing-pivot-filters-in-pivot-table

Do you have any workaround for this?

[Dinesh Babu Yadav]

Hi Aakash, 

 

Thanks for contacting Syncfusion support. Please find the response below. 

 

We have analyzed your query and understand that you should clear the filters on click of button. You can clear the filterSettings on button click by clearing the same. Kindly find the following code snippet. 

 

Code snippet: [JavaScript] 

<script> 

 

    document.getElementById("element").addEventListener('click', function () { 

        var pivotObj = document.getElementById('PivotView').ej2_instances[0]; 

        pivotObj.dataSourceSettings.filterSettings = []; 

         

    }); 

 

</script> 

 

Meanwhile, we have prepared a sample for your reference. Please find the sample link below. 

Sample Link: https://www.syncfusion.com/downloads/support/forum/146019/ze/WebApplication1-2127032141 

Screenshots: 

Initial rendering 

 

 

After the button click: 

 

 

 

Please let us know if you have any concerns. 

 

Regards, 

Dinesh Babu Yadav