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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Clearing Pivot Filters in Pivot Table

Thread ID:

Created:

Updated:

Platform:

Replies:

144315 Apr 30,2019 10:34 AM UTC May 3,2019 11:21 AM UTC ASP.NET Web Forms 2
loading
Tags: XlsIO
Mani Barathi Saravanan
Asked On April 30, 2019 10:34 AM UTC

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 [Syncfusion]
Replied On May 2, 2019 04:54 PM UTC

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 [Syncfusion]
Replied On May 3, 2019 11:21 AM UTC

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. 


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

Regards, 
Sivaneswaran . A

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon