GrapeCity.Documents.Excel.PivotFieldCalculation

Enum PivotFieldCalculation

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Specifies the subtotal function.

public enum PivotFieldCalculation

Fields

DifferenceFrom = 0

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

Index = 1

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

NoAdditionalCalculation = 2

No calculation.

PercentDifferenceFrom = 3

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

PercentOf = 4

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

PercentOfColumn = 5

Percentage of the total for the column or series.

PercentOfParent = 6

Percentage of the total of the specified parent Base field.

PercentOfParentColumn = 7

Percentage of the total of the parent column.

PercentOfParentRow = 8

Percentage of the total of the parent row.

PercentOfRow = 9

Percentage of the total for the row or category.

PercentOfTotal = 10

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

PercentRunningTotal = 11

Percentage of the running total of the specified Base field.

RankAscending = 12

Rank smallest to largest.

RankDecending = 13

Rank largest to smallest.

RunningTotal = 14

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