Class CalculationType
Calculation type defines the view for a particular computational object (or value field).
Inheritance
Namespace: Syncfusion.PivotAnalysis.UWP
Assembly: Syncfusion.PivotAnalysis.UWP.dll
Syntax
public sealed class CalculationType : EnumFields
DifferenceFrom
Displays values as the difference from the value of the BaseItem in the BaseField.
Declaration
public const CalculationType DifferenceFromField Value
| Type |
|---|
| CalculationType |
Formula
Displays a calculation based on a well formed algebraic expression involving other calculations.
Declaration
public const CalculationType FormulaField Value
| Type |
|---|
| CalculationType |
Index
Displays a value cell as an index value based on PivotEngine generation.
Declaration
public const CalculationType IndexField Value
| Type |
|---|
| CalculationType |
NoCalculation
Remove the custom calculations and restore to original values.
Declaration
public const CalculationType NoCalculationField Value
| Type |
|---|
| CalculationType |
PercentageOf
Displays values as a percentage of the value of the BaseItem in the BaseField.
Declaration
public const CalculationType PercentageOfField Value
| Type |
|---|
| CalculationType |
PercentageOfColumnTotal
Displays all value cells in each column as a percentage of its corresponding column total.
Declaration
public const CalculationType PercentageOfColumnTotalField Value
| Type |
|---|
| CalculationType |
PercentageOfDifferenceFrom
Displays values as the percentage difference from the value of the BaseItem in the BaseField.
Declaration
public const CalculationType PercentageOfDifferenceFromField Value
| Type |
|---|
| CalculationType |
PercentageOfGrandTotal
Displays a value cell as a percentage of grand total of all value cells of PivotEngine.
Declaration
public const CalculationType PercentageOfGrandTotalField Value
| Type |
|---|
| CalculationType |
PercentageOfParentColumnTotal
Displays a value cell as a percentage of parent column item values.
Declaration
public const CalculationType PercentageOfParentColumnTotalField Value
| Type |
|---|
| CalculationType |
PercentageOfParentRowTotal
Displays a value cell as a percentage of parent row item values.
Declaration
public const CalculationType PercentageOfParentRowTotalField Value
| Type |
|---|
| CalculationType |
PercentageOfParentTotal
Displays a value cell as a percentage of BaseField (Parent Row/Column Total).
Declaration
public const CalculationType PercentageOfParentTotalField Value
| Type |
|---|
| CalculationType |
PercentageOfRowTotal
Displays all value cells in each row as a percentage of its corresponding row total.
Declaration
public const CalculationType PercentageOfRowTotalField 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 PercentageOfRunningTotalInField 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 RankLargestToSmallestField 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 RankSmallestToLargestField Value
| Type |
|---|
| CalculationType |
RunningTotalIn
Displays the value of successive items in the BaseField as a running total.
Declaration
public const CalculationType RunningTotalInField Value
| Type |
|---|
| CalculationType |