GrapeCity.Documents.Excel.IPivotFilter.Value1

Value1 Property

Value1

Gets the first filter value.

This value corresponds to the first criterion stored in the pivot filter.

Declaration

object Value1 { get; }

ReadOnly Property Value1 As Object

Examples

object[,] sourceData = {
    {"Product", "Amount"},
    {"Laptop", 900},
    {"Monitor", 300}
};
worksheet.Range["A1:B3"].Value = sourceData;
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B3"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "PivotTable1");
IPivotField productField = pivotTable.PivotFields["Product"];
IPivotFilter filter = productField.PivotFilters.Add(PivotFilterType.CaptionContains, "top");
object value1 = filter.Value1;