Document Solutions for Excel, Java Edition | Document Solutions
com.grapecity.documents.excel Package / SubtotalType Enumeration
In This Topic
    SubtotalType Enumeration
    In This Topic
    Specifies the type of subtotal for the specified pivot field.
    AutomaticSpecifies that the subtotal type is the same as the value of PivotDataConsolidationFunction. If Automatic is used, all other subtotals should be removed.
    AverageSpecifies the average.
    CountSpecifies the number of values.
    CountNumsSpecifies the number of numeric values.
    MaxSpecifies the maximum.
    MinSpecifies the minimum.
    NoneSpecifies no subtotal is used.
    StdDevSpecifies StdDev.
    StdDevPSpecifies StdDevP.
    SumSpecifies sum.
    VarSpecifies Var.
    VarPSpecifies VarP.
    Inheritance Hierarchy


    See Also