Documents for Excel .NET Edition | GCDocuments
GrapeCity.Documents.Excel Namespace / PivotFieldCalculation Enumeration
In This Topic
    PivotFieldCalculation Enumeration
    In This Topic
    Specifies the subtotal function.
    Syntax
    public enum PivotFieldCalculation : System.Enum 
    Members
    MemberDescription
    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)).
    NoAdditionalCalculation 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.
    RankDecending Rank largest to smallest.
    RunningTotal Data for successive items in the Base field as a running total.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Documents.Excel.PivotFieldCalculation

    See Also