Class CalculationType

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

Inheritance
System.Object
CalculationType
Namespace: Syncfusion.PivotAnalysis.UWP
Assembly: Syncfusion.PivotAnalysis.UWP.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

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

Extension Methods