GrapeCity.Documents.Excel.IPivotTable.AllowMultipleFilters

AllowMultipleFilters Property

AllowMultipleFilters

Gets or sets whether pivot fields in the pivot table can have multiple filters applied at the same time.

Use this property to determine whether the pivot table allows a single pivot field to keep more than one filter condition simultaneously.

Declaration

bool AllowMultipleFilters { get; set; }

Property AllowMultipleFilters As Boolean

Examples

worksheet.Range["A1:C5"].Value = new object[,] {
    {"Category", "Product", "Amount"},
    {"Fruit", "Apple", 120},
    {"Fruit", "Banana", 90},
    {"Drink", "Tea", 60},
    {"Drink", "Coffee", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:C5"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["E1"], "SalesPivot");
pivotTable.AllowMultipleFilters = true;
bool allowMultipleFilters = pivotTable.AllowMultipleFilters;