Class CalculationType

Calculation type defines the view for a particular computational object (or value field).

Inheritance

System.Object

CalculationType

Namespace: Syncfusion.XlsIO.Implementation.PivotAnalysis

Assembly: Syncfusion.XlsIO.NET.dll

Syntax

public sealed class CalculationType : Enum

Fields

DifferenceFrom

Displays values as the difference from the value of the BaseItem in the BaseField.

Declaration

public const CalculationType DifferenceFrom

Field Value

Type
CalculationType

Distinct

Displays the subtotals based on the distinct values of BaseItem defined for calculation item.

Declaration

public const CalculationType Distinct

Field Value

Type
CalculationType

Formula

Displays a calculation based on a well formed algebraic expression involving other calculations.

Declaration

public const CalculationType Formula

Field Value

Type
CalculationType

Index

Displays a value cell as an index value based on PivotEngine generation.

Declaration

public const CalculationType Index

Field Value

Type
CalculationType

NoCalculation

Remove the custom calculations and restore to original values.

Declaration

public const CalculationType NoCalculation

Field Value

Type
CalculationType

PercentageOf

Displays values as a percentage of the value of the BaseItem in the BaseField.

Declaration

public const CalculationType PercentageOf

Field Value

Type
CalculationType

PercentageOfColumnTotal

Displays all value cells in each column as a percentage of its corresponding column total.

Declaration

public const CalculationType PercentageOfColumnTotal

Field Value

Type
CalculationType

PercentageOfDifferenceFrom

Displays values as the percentage difference from the value of the BaseItem in the BaseField.

Declaration

public const CalculationType PercentageOfDifferenceFrom

Field Value

Type
CalculationType

PercentageOfGrandTotal

Displays a value cell as a percentage of grand total of all value cells of PivotEngine.

Declaration

public const CalculationType PercentageOfGrandTotal

Field Value

Type
CalculationType

PercentageOfParentColumnTotal

Displays a value cell as a percentage of parent column item values.

Declaration

public const CalculationType PercentageOfParentColumnTotal

Field Value

Type
CalculationType

PercentageOfParentRowTotal

Displays a value cell as a percentage of parent row item values.

Declaration

public const CalculationType PercentageOfParentRowTotal

Field Value

Type
CalculationType

PercentageOfParentTotal

Displays a value cell as a percentage of BaseField (Parent Row/Column Total).

Declaration

public const CalculationType PercentageOfParentTotal

Field Value

Type
CalculationType

PercentageOfRowTotal

Displays all value cells in each row as a percentage of its corresponding row total.

Declaration

public const CalculationType PercentageOfRowTotal

Field Value

Type
CalculationType

PercentageOfRunningTotalIn

Calculates the value of successive items in the BaseField that are displayed as a running total as a percentage.

Declaration

public const CalculationType PercentageOfRunningTotalIn

Field Value

Type
CalculationType

RankLargestToSmallest

Displays the rank of selected values in a specific field, listing the largest item in the field as 1 and each smaller value will have a higher rank value.

Declaration

public const CalculationType RankLargestToSmallest

Field Value

Type
CalculationType

RankSmallestToLargest

Displays the rank of selected values in a specific field, listing the smallest item in the field as 1 and each larger value will have a higher rank value.

Declaration

public const CalculationType RankSmallestToLargest

Field Value

Type
CalculationType

RunningTotalIn

Displays the value of successive items in the BaseField as a running total.

Declaration

public const CalculationType RunningTotalIn

Field Value

Type
CalculationType