TopBottomRuleFormatCondition.Rule Property

Specifies the rule for the top/bottom conditional formatting.

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#

public TopBottomRule Rule { get; set; }

VB.NET

Public Property Rule As TopBottomRule

Property Value

Type	Description
TopBottomRule	The TopBottomRule object, that is the rule formatting only top or bottom rank values.

Available values:

Name	Description
TopItems	The style is applied to cells whose values are the largest for the field. The number of cells is specified by the TopBottomRuleFormatCondition.Threshold (TopBottomRuleFormatCondition.Threshold) property.
TopPercent	The style is applied to cells whose values are the largest for the field. The percentage of cells is specified by the TopBottomRuleFormatCondition.Threshold (TopBottomRuleFormatCondition.Threshold) property.
BottomItems	The style is applied to cells whose values are the lowest for the field. The number of cells is specified by the TopBottomRuleFormatCondition.Threshold (TopBottomRuleFormatCondition.Threshold) property.
BottomPercent	The style is applied to cells whose values are the lowest for the field. The percentage of cells is specified by the TopBottomRuleFormatCondition.Threshold (TopBottomRuleFormatCondition.Threshold) property.
AboveAverage	The style is applied to cells whose values are above the average value for the field.
BelowAverage	The style is applied to cells whose values are below the average value for the field.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Rule property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

XAML

wpf-pivot-grid-apply-format-conditions-to-data-cells/CS/WpfPivotGridConditionalFormatting/MainWindow.xaml#L56

                               RowName="fieldSalesPerson"
                               Rule="TopItems">
<dxpg:TopBottomRuleFormatCondition.Format>