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

Subscribe to this post

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???

Reply | Reply with quote

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.

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

Reply | Reply with quote

CONTACT US

CONTACT US