We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Clearing Pivot Filters in Pivot Table

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:



Do you have any workaround for this?



1 Reply

DB Dinesh Babu Yadav Syncfusion Team July 17, 2019 04:42 AM

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. 
Screenshots: 
Initial rendering 
 
 
After the button click: 
 
 
 
Please let us know if you have any concerns. 
 
Regards, 
Dinesh Babu Yadav 


Loader.
Live Chat Icon For mobile
Up arrow icon