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

Subscribe to this post

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?

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

Reply | Reply with quote

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 3^rd 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

Reply | Reply with quote

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.

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

Reply | Reply with quote

CONTACT US

Clearing Pivot Filters in Pivot Table

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US