Rank Types

• Oct 15, 2023
• 5 minutes to read

Rank summary display types are designed to display ranks of summary values in their columns and rows. To employ rank display values, use RankBinding in Optimized mode.

The following rank types are available:

Rank in a Column: Largest to Smallest

Displays the summary value’s rank among other values in the same column, where the largest value in the column is ranked as 1, and corresponding higher ranks are assigned to all values that are less than the largest value.

Example

View Example: PivotGrid for WPF - How to Change SummaryDisplayType in the Context Menu

HeaderMenuHelper.cs

static void itemClickEventHandler(object sender, ItemClickEventArgs e) {
    BarItem barItem = sender as BarItem;
    object[] barItemInfo = (object[])barItem.Tag;
    PivotGridField field = (PivotGridField)barItemInfo[0];
    FieldSummaryDisplayType newValue = (FieldSummaryDisplayType)barItemInfo[2];
    DataSourceColumnBinding sourceBinding = new DataSourceColumnBinding("Value");
    switch(newValue){
    // ...
        case FieldSummaryDisplayType.RankInColumnLargestToSmallest:
            field.DataBinding = new RankBinding(
                sourceBinding,
                CalculationPartitioningCriteria.ColumnValue,
                RankType.Dense, FieldSortOrder.Descending);
            break;
            // ...
    }
    field.Tag = newValue;
    (field.Parent as PivotGridControl).ReloadData();
}

HeaderMenuHelper.vb

        Private Shared Sub itemClickEventHandler(ByVal sender As Object, ByVal e As ItemClickEventArgs)
            Dim barItem As BarItem = TryCast(sender, BarItem)
            Dim barItemInfo() As Object = CType(barItem.Tag, Object())
            Dim field As PivotGridField = DirectCast(barItemInfo(0), PivotGridField)
            Dim newValue As FieldSummaryDisplayType = DirectCast(barItemInfo(2), FieldSummaryDisplayType)
            Dim sourceBinding As New DataSourceColumnBinding("Value")
            Select Case newValue
            ' ...
                Case FieldSummaryDisplayType.RankInColumnLargestToSmallest
                    field.DataBinding = New RankBinding(sourceBinding, CalculationPartitioningCriteria.ColumnValue, RankType.Dense, FieldSortOrder.Descending)
                    ' ...
            End Select
            field.Tag = newValue
            TryCast(field.Parent, PivotGridControl).ReloadData()
        End Sub

Note

Set PivotGridField.SummaryDisplayType to FieldSummaryDisplayType.RankInColumnLargestToSmallest in Legacy and LegacyOptimized modes.

Rank in a Column: Smallest to Largest

Displays the summary value’s rank among other values in the same column, where the lowest value in the column is ranked as 1 and ranks increase depending on the other values.

Example

View Example: PivotGrid for WPF - How to Change SummaryDisplayType in the Context Menu

HeaderMenuHelper.cs

static void itemClickEventHandler(object sender, ItemClickEventArgs e) {
    BarItem barItem = sender as BarItem;
    object[] barItemInfo = (object[])barItem.Tag;
    PivotGridField field = (PivotGridField)barItemInfo[0];
    FieldSummaryDisplayType newValue = (FieldSummaryDisplayType)barItemInfo[2];
    DataSourceColumnBinding sourceBinding = new DataSourceColumnBinding("Value");
    switch(newValue){
    // ...
        case FieldSummaryDisplayType.RankInColumnSmallestToLargest:
            field.DataBinding = new RankBinding(
                sourceBinding,
                CalculationPartitioningCriteria.ColumnValue,
                RankType.Dense, FieldSortOrder.Ascending);
            break;
            // ...
    }
    field.Tag = newValue;
    (field.Parent as PivotGridControl).ReloadData();
}

HeaderMenuHelper.vb

        Private Shared Sub itemClickEventHandler(ByVal sender As Object, ByVal e As ItemClickEventArgs)
            Dim barItem As BarItem = TryCast(sender, BarItem)
            Dim barItemInfo() As Object = CType(barItem.Tag, Object())
            Dim field As PivotGridField = DirectCast(barItemInfo(0), PivotGridField)
            Dim newValue As FieldSummaryDisplayType = DirectCast(barItemInfo(2), FieldSummaryDisplayType)
            Dim sourceBinding As New DataSourceColumnBinding("Value")
            Select Case newValue
            ' ...
                Case FieldSummaryDisplayType.RankInColumnSmallestToLargest
                    field.DataBinding = New RankBinding(sourceBinding, CalculationPartitioningCriteria.ColumnValue, RankType.Dense, FieldSortOrder.Ascending)
                    ' ...
            End Select
            field.Tag = newValue
            TryCast(field.Parent, PivotGridControl).ReloadData()
        End Sub

Note

Set PivotGridField.SummaryDisplayType to FieldSummaryDisplayType.RankInColumnSmallestToLargest in Legacy and LegacyOptimized modes.

Rank in a Row: Largest to Smallest

Displays the summary value’s rank among other values in the same row, where the largest value in the row is ranked as 1, and corresponding higher ranks are assigned to all values that are less than the largest value.

Example

View Example: PivotGrid for WPF - How to Change SummaryDisplayType in the Context Menu

HeaderMenuHelper.cs

static void itemClickEventHandler(object sender, ItemClickEventArgs e) {
    BarItem barItem = sender as BarItem;
    object[] barItemInfo = (object[])barItem.Tag;
    PivotGridField field = (PivotGridField)barItemInfo[0];
    FieldSummaryDisplayType newValue = (FieldSummaryDisplayType)barItemInfo[2];
    DataSourceColumnBinding sourceBinding = new DataSourceColumnBinding("Value");
    switch(newValue){
    // ...
        case FieldSummaryDisplayType.RankInRowLargestToSmallest:
            field.DataBinding = new RankBinding(
                sourceBinding,
                CalculationPartitioningCriteria.RowValue,
                RankType.Dense, FieldSortOrder.Descending);
            break;
            // ...
    }
    field.Tag = newValue;
    (field.Parent as PivotGridControl).ReloadData();
}

HeaderMenuHelper.vb

        Private Shared Sub itemClickEventHandler(ByVal sender As Object, ByVal e As ItemClickEventArgs)
            Dim barItem As BarItem = TryCast(sender, BarItem)
            Dim barItemInfo() As Object = CType(barItem.Tag, Object())
            Dim field As PivotGridField = DirectCast(barItemInfo(0), PivotGridField)
            Dim newValue As FieldSummaryDisplayType = DirectCast(barItemInfo(2), FieldSummaryDisplayType)
            Dim sourceBinding As New DataSourceColumnBinding("Value")
            Select Case newValue
            ' ...
                Case FieldSummaryDisplayType.RankInRowLargestToSmallest
                    field.DataBinding = New RankBinding(sourceBinding, CalculationPartitioningCriteria.RowValue, RankType.Dense, FieldSortOrder.Descending)
                    ' ...
            End Select
            field.Tag = newValue
            TryCast(field.Parent, PivotGridControl).ReloadData()
        End Sub

Note

Set PivotGridField.SummaryDisplayType to FieldSummaryDisplayType.RankInRowLargestToSmallest in Legacy and LegacyOptimized modes.

Rank in a Row: Smallest to Largest

Displays the summary value’s rank among other values in the same row, where the lowest value in the row is ranked as 1, and corresponding higher ranks are assigned to all values that exceed the lowest value.

Example

View Example: PivotGrid for WPF - How to Change SummaryDisplayType in the Context Menu

HeaderMenuHelper.cs

static void itemClickEventHandler(object sender, ItemClickEventArgs e) {
    BarItem barItem = sender as BarItem;
    object[] barItemInfo = (object[])barItem.Tag;
    PivotGridField field = (PivotGridField)barItemInfo[0];
    FieldSummaryDisplayType newValue = (FieldSummaryDisplayType)barItemInfo[2];
    DataSourceColumnBinding sourceBinding = new DataSourceColumnBinding("Value");
    switch(newValue){
    // ...
        case FieldSummaryDisplayType.RankInRowSmallestToLargest:
            field.DataBinding = new RankBinding(
                sourceBinding,
                CalculationPartitioningCriteria.ColumnValue,
                RankType.Dense, FieldSortOrder.Ascending);
            break;
            // ...
    }
    field.Tag = newValue;
    (field.Parent as PivotGridControl).ReloadData();
}

HeaderMenuHelper.vb

        Private Shared Sub itemClickEventHandler(ByVal sender As Object, ByVal e As ItemClickEventArgs)
            Dim barItem As BarItem = TryCast(sender, BarItem)
            Dim barItemInfo() As Object = CType(barItem.Tag, Object())
            Dim field As PivotGridField = DirectCast(barItemInfo(0), PivotGridField)
            Dim newValue As FieldSummaryDisplayType = DirectCast(barItemInfo(2), FieldSummaryDisplayType)
            Dim sourceBinding As New DataSourceColumnBinding("Value")
            Select Case newValue
            ' ...
                Case FieldSummaryDisplayType.RankInRowSmallestToLargest
                    field.DataBinding = New RankBinding(sourceBinding, CalculationPartitioningCriteria.ColumnValue, RankType.Dense, FieldSortOrder.Ascending)
                    ' ...
            End Select
            field.Tag = newValue
            TryCast(field.Parent, PivotGridControl).ReloadData()
        End Sub

Note

Set PivotGridField.SummaryDisplayType to FieldSummaryDisplayType.RankInRowSmallestToLargest in Legacy and LegacyOptimized modes.