Enabling Allow multiple filters per field

Question

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 · Answer

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.  

UG link : https://help.syncfusion.com/file-formats/xlsio/working-with-pivot-tables#applying-row-or-column-filters  
 
Kindly try this and let us know whether it helps.  

Regards,  Sivaneswaran . A