Hi,
I want to know in the pivot table, how do I add Report Filter not just column or row?
Thanks!
pivotTable.ReportFilters[1].IsMultipleSelect = false;
pivotTable.ReportFilters[1].FieldString = "FedEx";
pivotTable.ReportFilters[1].FilterItemStrings=new List<string>() { "114", "110" };
Dim sheet1 As Worksheet = workbook.Worksheets(0)
sheet1.Name = "Test"
Dim sheet2 As Worksheet = workbook.Worksheets(2)
sheet2.Name = "Data Source"
Dim dataRange As CellRange = sheet2.Range("A1:G10")
Dim cache As PivotCache = workbook.PivotCaches.Add(dataRange)
Dim pt As PivotTable = sheet1.PivotTables.Add("Item Analysis", sheet2.Range("A1"), cache)
Dim filter As Spire.Xls.Core.Spreadsheet.PivotTables.PivotReportFilter = New Spire.Xls.Core.Spreadsheet.PivotTables.PivotReportFilter("Item#", True)
Dim ra1 = pt.PivotFields("Category")
Dim ra2 = pt.PivotFields("Destination")
ra1.Axis = AxisTypes.Column
ra2.Axis = AxisTypes.Row
pt.ReportFilters.Add(filter)
pt.DataFields.Add(pt.PivotFields("Quantity"), "Quantity", SubtotalTypes.Sum)
workbook.SaveToFile("test.xlsx", ExcelVersion.Version2007)
Spire.Xls.Core.Spreadsheet.PivotTables.XlsPivotTable pivotTable = sheet.PivotTables[0] as Spire.Xls.Core.Spreadsheet.PivotTables.XlsPivotTable;
Spire.Xls.Core.Spreadsheet.PivotTables.PivotReportFilter filter = new Spire.Xls.Core.Spreadsheet.PivotTables.PivotReportFilter("PRNT_PROD_CD",true);
pivotTable.ReportFilters.Add(filter);