[]
DEMOS DOCS API BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

GrapeCity.Spreadsheet.PivotTables.PivotFieldCalculation

PivotFieldCalculation Enum

Represents the type of calculation performed by a data PivotField when a custom calculation is used.

Namespace: GrapeCity.Spreadsheet.PivotTables
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public enum PivotFieldCalculation : byte
Public Enum PivotFieldCalculation As Byte

Fields

Name Description
DifferenceFrom

The difference from the value of the Base item in the Base field.
Index

Data calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)).
NoCalculation

No calculation.
PercentDifferenceFrom

Percentage difference from the value of the Base item in the Base field.
PercentOf

Percentage of the value of the Base item in the Base field.
PercentOfColumn

Percentage of the total for the column or series.
PercentOfParent

Percentage of the total of the specified parent Base field.
PercentOfParentColumn

Percentage of the total of the parent column.
PercentOfParentRow

Percentage of the total of the parent row.
PercentOfRow

Percentage of the total for the row or category.
PercentOfTotal

Percentage of the grand total of all the data or data points in the report.
PercentRunningTotal

Percentage of the running total of the specified Base field.
RankAscending

Rank smallest to largest.
RankDescending

Rank largest to smallest.
RunningTotal

Data for successive items in the Base field as a running total.