Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Collapse]Data Shaping
    [Collapse]Aggregation
     [Collapse]Summaries
       Summary Overview
       Automatic Summaries
       Custom Summaries
      [Collapse]Summary Display Modes
        Variation Modes
        Percentage Modes
        Rank Modes
        Index Mode
       Accessing Summary Values
       Obtaining Underlying Data (Drill-Down)
     [Expand]Totals
      Aggregation Levels
     Grouping
    [Expand]Sorting
    [Expand]Filtering
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Expand]Layout
   [Expand]Appearance
   [Expand]Data Export
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]Examples
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[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

Rank Modes

Use rank summary display modes when you need to replace raw summary values with their ranks calculated among other values located in the same column or row.

The following modes are available.

  • Value's Position in Its Column, Ranking Values From Largest to Smallest

    Displays the summary value's rank among other values in the same column, with the largest value in the column ranked as 1, and each smaller value assigned a higher rank.

    This mode is specified by the PivotSummaryDisplayType.RankInColumnLargestToSmallest value.

  • Value's Position in Its Column, Ranking Values From Smallest to Largest

    Displays the summary value's rank among other values in the same column, with the smallest value in the column ranked as 1, and each larger value assigned a higher rank.

    This mode is specified by the PivotSummaryDisplayType.RankInColumnSmallestToLargest value.

  • Value's Position in Its Row, Ranking Values From Largest to Smallest

    Displays the summary value's rank among other values in the same row, with the largest value in the row ranked as 1, and each smaller value assigned a higher rank.

    This mode is specified by the PivotSummaryDisplayType.RankInRowLargestToSmallest value.

  • Value's Position in Its Row, Ranking Values From Smallest to Largest

    Displays the summary value's rank among other values in the same row, with the smallest value in the row ranked as 1, and each larger value assigned a higher rank.

    This mode is specified by the PivotSummaryDisplayType.RankInRowSmallestToLargest value.

Expanded See Also

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