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

Enabling Allow multiple filters per field

Thread ID:

Created:

Updated:

Platform:

Replies:

144310 Apr 30,2019 06:50 AM UTC May 2,2019 08:39 AM UTC ASP.NET Web Forms (Classic) 1
loading
Tags: XlsIO
Mani Barathi Saravanan
Asked On April 30, 2019 06:50 AM UTC

How to enable "Allow multiple filters per field" in pivot Table options?
In Excel.Interop I do  it by setting the property AllowMultipleFilters of pivottable to true, 
Is there a property  or function to be called in syncfusion to accomplish this???

Sivaneswaran Amsu [Syncfusion]
Replied On May 2, 2019 08:39 AM UTC

Hi Mani, 

Thank you for contacting Syncfusion support.  

You can enable multiple filters by setting PivotTableOptions.IsMultiFiledFilters property value to TRUE.  
  
Code snippet:  
using (ExcelEngine excelEngine = new ExcelEngine())  
{  
    IApplication application = excelEngine.Excel;  
    application.DefaultVersion = ExcelVersion.Excel2013;  
  
    IWorkbook workbook = application.Workbooks.Open("PivotTable.xlsx");  
    IWorksheet sheet = workbook.Worksheets[1];  
    IPivotTable pivotTable = sheet.PivotTables[0];  
  
    (pivotTable.Options as PivotTableOptions).IsMultiFieldFilter = true;  
  
    workbook.SaveAs("PivotFieldFilters.xlsx");  
    excelEngine.ThrowNotSavedOnDestroy = false;  
}  
 
Please refer the UG documentation from the following link to add multiple filters for a field in pivot table.  

 
Kindly try this and let us know whether it helps.  

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