GemBox.Spreadsheet
  • Overview
  • Examples
  • Free version
  • Support
  • Pricelist

    Show / Hide Table of Contents

    PivotFieldDisplayFormat Enum

    Namespace:
    GemBox.Spreadsheet.PivotTables
    Assembly:
    GemBox.Spreadsheet.dll

    Represents a data PivotField display format.

    • C#
    • VB.NET
    public enum PivotFieldDisplayFormat
    Public Enum PivotFieldDisplayFormat

    Fields

    Difference

    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)).

    Normal

    No calculation.

    Percent

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

    PercentageOfColumn

    Percentage of the total for the column or series.

    PercentageOfDifference

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

    PercentageOfParent

    Percentage of the total of the specified parent Base field.

    PercentageOfParentColumn

    Percentage of the total of the parent column.

    PercentageOfParentRow

    Percentage of the total of the parent row.

    PercentageOfRow

    Percentage of the total for the row or category.

    PercentageOfRunningTotal

    Rank largest to smallest.

    PercentageOfTotal

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

    RankAscending

    Rank smallest to largest.

    RankDecending

    Rank largest to smallest.

    RunTotal

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

    Back to top

    Facebook • Twitter • LinkedIn

    © GemBox Ltd. — All rights reserved.