Clearing Pivot Filters in Pivot Table

[Mani Barathi Saravanan]

How to Clear Manual, Label and Value filters in pivot Table?

or 

How to Select all pivot Items for a pivotFiled in pivot Table?

[Sivaneswaran Amsu]

Hi Mani, 

  

  

Query	Answer
How to Clear Manual, Label and Value filters in pivot Table?	We are analyzing your query and we will update the further details on 3rd May 2019
How to Select all pivot Items for a pivotFiled in pivot Table?	We suggest to you use below code to select the all pivot items for a pivotField.     Code snippet:  IPivotField pivotField = pivotTable.Fields[1];  IPivotFieldItems items = pivotField.Items;

  

  

  

Regards, 

Sivaneswaran . A

[Sivaneswaran Amsu]

Hi Mani, 

Currently we don’t have support for clear Label and Value filters in pivot table. However, we have prepared the workaround sample to clear the filter in pivot table which can be downloaded from the following link. 

Sample link : http://www.syncfusion.com/downloads/support/forum/144315/ze/XlsIO_Sample1427583834.zip  

Kindly try this and let us know if this helpful for your requirement. 

Regards, 

Sivaneswaran . A