Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Collapse]Data Shaping
    [Collapse]Summarization
     [Collapse]Summaries
       Summaries Overview
       Automatic Summaries
       Custom Summaries
      [Collapse]Summary Display Modes
        Variation Modes
        Percentage Modes
        Rank Modes
        Index Mode
       Accessing Cell Values
       Obtaining Underlying Data (Drill-Down)
     [Expand]Totals
      Aggregation Levels
     Grouping
    [Expand]Sorting
    [Expand]Filtering
    [Expand]Editing
     Data Formatting
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]Design-time Features
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Percentage Modes

Percentage summary display modes are used to display percentages of Total and Grand Total values in data cells.

The following percentage modes are available.

  • PivotSummaryDisplayType.PercentOfColumn

    The percentage of the Column Total value is displayed in the cell.

    In the following image, the SummaryDisplayType properties of the two data fields are set to Default and PercentOfColumn respectively.

    Cell values are calculated as follows.

    "Chai - September - PercentOfColumn" 0.4935 = 518.4/1050.4 518.4 is the actual sum calculated against the Product Sales field for the "Chai - September" cell, and 1050.4 is the Total value calculated for this column ("Beverages - September").
    "Beverages Total - September - PercentOfColumn" 0.814 = 1050.4/1290.4 1050.4 is the Total value calculated for the "Beverages - September" column against the Product Sales field, and 1290.4 is the Grand Total value calculated for this column ("September").
  • PivotSummaryDisplayType.PercentOfColumnGrandTotal

    The percentage of the Column Grand Total value is displayed in the cell.

    In the following image, the SummaryDisplayType properties of the two data fields are set to Default and PercentOfColumnGrandTotal respectively.

    For instance, the "Chai - September - PercentOfColumnGrandTotal" cell value is calculated as follows: 0.4017 = 518.4/1290.4, where 518.4 - is the actual sum calculated against the Product Sales field for the "Chai - September" cell, and 1290.4 is the Grand Total value calculated for this column ("September").

  • PivotSummaryDisplayType.PercentOfRow

    The percentage of the Row Total value is displayed in the cell.

    In the following image, the SummaryDisplayType properties of the two data fields are set to Default and PercentOfRow respectively.

    Cell values are calculated as follows.

    "Beverages - August 1994 - PercentOfRow" 0.3228 = 2226.9/6898.58 2226.9 is the actual sum calculated against the Product Sales field for the "Beverages - August 1994" cell, and 6898.58 is the Total value calculated for this row ("Beverages - 1994 Total").
    "Beverages - 1994 Total - PercentOfRow" 0.3377 = 6898.58/20426.1 6898.58 is the Total value calculated for the "Beverages - 1994" row against the Product Sales field, and 20426.1 is the Grand Total value calculated for this row ("Beverages").
  • PivotSummaryDisplayType.PercentOfRowGrandTotal

    The percentage of the Row Grand Total value is displayed in the cell.

    In the following image, the SummaryDisplayType properties of the two data fields are set to Default and PercentOfRowGrandTotal respectively.

    For instance, the "Beverages - August 1994 - PercentOfRowGrandTotal" cell value is calculated as follows: 0.109 = 2226.9/20426.1, where 2226.9 - is the actual sum calculated against the Product Sales field for the "Beverages - August 1994" cell, and 20426.1 is the Grand Total value calculated for this row ("Beverages").

  • PivotSummaryDisplayType.PercentOfGrandTotal

    The percentage of the Grand Total value is displayed in the cell.

    In the following image, the SummaryDisplayType properties of the two data fields are set to Default and PercentOfGrandTotal respectively.

    For instance, the "Chai - September - PercentOfGrandTotal" cell value is calculated as follows: 0.1595 = 518.4/3249.6, where 518.4 - is the actual sum calculated against the Product Sales field for the "Chai - September" cell, and 3249.6 is the Grand Total value calculated against all data cells.

Note

In percentage summary display modes, values are automatically formatted as percentages. To specify custom formatting settings, use the data field's PivotGridFieldBase.CellFormat property.

How would you rate this topic?​​​​​​​