Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

RankBinding Class

Defines the calculation of a ranking in the window.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v24.2.dll

NuGet Package: DevExpress.Wpf.PivotGrid

#Declaration

public class RankBinding :
    CalculationBinding

#Remarks

To bind a Pivot Grid field to the result of the calculation in Optimized mode, follow the steps listed below.

  1. Create an instance of the RankBinding class with the Source property set to the DevExpress.XtraPivotGrid.DataBindingBase descendant instance.
  2. Specify the window frame.
  3. Assign the RankBinding instance to the PivotGridField.DataBinding property.

The example below shows how to use RankBinding to rank sales by month for the year.

View Example: Pivot Grid Optimized Mode - Field Calculation Data Binding

<dxpg:PivotGridControl
<!-- ... -->
    DataProcessingEngine="Optimized"
    <!-- ... -->
    <dxpg:PivotGridControl.Fields>
    <!-- ... -->
        <dxpg:PivotGridField
            Area="DataArea"
            AreaIndex="1"
            Caption="Rank"
            Name="fieldRank">
            <dxpg:PivotGridField.DataBinding>
                <dxpg:RankBinding
                    Order="Descending"
                    PartitioningCriteria="ColumnValueAndRowParentValue"
                    RankType="Unique">
                    <dxpg:RankBinding.Source>
                        <dxpg:DataSourceColumnBinding ColumnName="Extended Price" />
                    </dxpg:RankBinding.Source>
                </dxpg:RankBinding>
            </dxpg:PivotGridField.DataBinding>
        </dxpg:PivotGridField>
        <!-- ... -->
    </dxpg:PivotGridControl.Fields>
</dxpg:PivotGridControl>
See Also