GrapeCity.Documents.Excel.IPivotField.Calculation

Calculation Property

Calculation

Gets or sets a PivotFieldCalculation value that represents the type of calculation performed by the specified field.

This property is valid only for data fields.

Declaration

PivotFieldCalculation Calculation { get; set; }

Property Calculation As PivotFieldCalculation

Examples

object[,] sourceData = {
    {"Product", "Country", "Amount"},
    {"Bike", "Australia", 100},
    {"Bike", "Canada", 80}
};
worksheet.Range["A1:C3"].Value = sourceData;
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:C3"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["E1"]);
pivotTable.PivotFields["Product"].Orientation = PivotFieldOrientation.RowField;
pivotTable.PivotFields["Country"].Orientation = PivotFieldOrientation.ColumnField;
pivotTable.PivotFields["Amount"].Orientation = PivotFieldOrientation.DataField;
IPivotField dataField = pivotTable.DataFields["Sum of Amount"];
dataField.Calculation = PivotFieldCalculation.PercentOf;
PivotFieldCalculation calculation = dataField.Calculation;