Enum PivotFieldCustomCalculation

Namespace: DRIT.Spreadsheet.Pivot

Assembly: DRIT.Spreadsheet.dll

Syntax

public enum PivotFieldCustomCalculation : int

Fields

Name	Description
DifferenceFrom	Display a value as the difference from the value of the Base item in the Base field.
Index	Calculate a value as follows:
NoCalculation	Turn off custom calculation.
PercentageDifferenceFrom	Display a value as the percentage difference from the value of the Base item in the Base field.
PercentageOf	Display a value as a percentage of the value of the Base item in the Base field.
PercentageOfColumnTotal	Display all the values in each column or series as a percentage of the total for the column or series.
PercentageOfGrandTotal	Display a value as a percentage of the grand total of all the values or data points.
PercentageOfParentColumnTotal	Calculate (value for the item) / (value for the parent item on columns).
PercentageOfParentRowTotal	Calculate (value for the item) / (value for the parent item on rows).
PercentageOfParentTotal	Calculate(value for the item) / (value for the parent item of the selected Base field).
PercentageOfRowTotal	Display the value in each row or category as a percentage of the total for the row or category.
PercentageOfRunningTotalIn	Display the value as a percentage for successive items in the Base field as a running total.
RankLargestToSmallest	Display the rank of selected values in a specific field, listing the largest item in the field as 1, and each smaller value with a higher rank value.
RankSmallestToLargest	Display the rank of selected values in a specific field, listing the smallest item in the field as 1, and each larger value with a higher rank value.
RunningTotalIn	Display the value for successive items in the Base field as a running total.