Enabling Allow multiple filters per field

[Mani Barathi Saravanan]

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]

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