Documents for Excel, Java Edition Documentation
com.grapecity.documents.excel Package / PivotFieldCalculation Enumeration
In This Topic
    PivotFieldCalculation Enumeration
    In This Topic
    Specifies the subtotal function.
    Members
    MemberDescription
    DifferenceFromThe difference from the value of the Base item in the Base field.
    IndexData calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)).
    NoAdditionalCalculationNo calculation.
    PercentDifferenceFromPercentage difference from the value of the Base item in the Base field.
    PercentOfPercentage of the value of the Base item in the Base field.
    PercentOfColumnPercentage of the total for the column or series.
    PercentOfParentPercentage of the total of the specified parent Base field.
    PercentOfParentColumnPercentage of the total of the parent column.
    PercentOfParentRowPercentage of the total of the parent row.
    PercentOfRowPercentage of the total for the row or category.
    PercentOfTotalPercentage of the grand total of all the data or data points in the report.
    PercentRunningTotalPercentage of the running total of the specified Base field.
    RankAscendingRank smallest to largest.
    RankDecendingRank largest to smallest.
    RunningTotalData for successive items in the Base field as a running total.
    Inheritance Hierarchy

    java.lang.Object
       java.lang.Enum
          com.grapecity.documents.excel.PivotFieldCalculation

    See Also