Function Property

Function

Declaration

ConsolidationFunction Function { get; set; }

Property [Function] As ConsolidationFunction

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 10},
    {"Fruit", 20},
    {"Drink", 5}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
IPivotField dataField = pivotTable.AddDataField(pivotTable.PivotFields["Amount"], "Sum of Amount", ConsolidationFunction.Sum);
ConsolidationFunction function = dataField.Function;