PivotTable PageFields DropDown FilterValue set in Excel

[vasanth]

Hi..

 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";

Thanks

Vasanth R

[Abirami Varadharajan]

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.  

  

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/PivotTable_(2)1072380945.zip    

   

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.  

  

Regards,  

Abirami.