[]
Gets the description of the pivot filter.
The description summarizes the filter criteria and can contain up to 255 characters.
string Description { get; }
ReadOnly Property Description As String
worksheet.Range["A1:B4"].Value = new object[,] {
{"Product", "Amount"},
{"Apple", 120},
{"Banana", 90},
{"Apricot", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
IPivotField productField = pivotTable.PivotFields["Product"];
productField.Orientation = PivotFieldOrientation.RowField;
IPivotFilter filter = productField.PivotFilters.Add(PivotFilterType.CaptionBeginsWith, "A");
string description = filter.Description;