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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

PivotTable PageFields DropDown FilterValue set in Excel

Thread ID:





128881 Feb 14,2017 04:19 AM UTC Feb 15,2017 07:34 AM UTC ASP.NET Core 1
Tags: XlsIO
Asked On February 14, 2017 04:19 AM UTC


 i am using Syncfusion.XlsIO for reporting.

i was trying to set the filter value in pivot table pageFields dropdown but i could not set the filter value in excel sheet.

This issue is the big score topper of my task 

kindly help me to solve the issue

 //'Create Pivot Filter object to apply filter to page Fields
  IPivotFilter filterValue = pivotTable.PageFields["CURRENCY"].PivotFilters.Add();
  //Page Field would be filtered with value 'Binder'
   filterValue.Value1 = "Binder";
   pivotTable.Fields["CURRENCY"].Items[0].Visible = true;

  //'Create Pivot Filter object to apply filter to page Fields
  IPivotFilter filterValue1 = pivotTable.Fields["CURRENCY"].PivotFilters.Add();
//Page Field would be filtered with value 'Binder'
  filterValue1.Value1 = "Binder";

Vasanth R

Abirami Varadharajan [Syncfusion]
Replied On February 15, 2017 07:34 AM UTC

Hi Vasanth,  
We are unable to reproduce the issue. We have prepared the sample as per your requirement and the sample can be downloaded from the following location.  
If your requirement is not met, then kindly modify and share us the issue reproducing sample. This will be helpful for us to provide prompt solution at the earliest.  


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

or the page will be automatically redirected to 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