In this dialog you can specify your own sort order for the current group for the chart. You define the groups and specify the individual values that belong in each group. To specify a new group click the "New" button to open the Formula Editor Dialog where you can enter a name for this group and a formula. The return type of the formula must be Boolean.

For example if you want to sort the order units by their price, you can define the groups of units you want to see in the list of the Specified Sort Order Dialog.

Create three formulas:

1. Formula name: "Less than 15 ", formula: "{Products.UnitPrice} < 15"
2. Formula name: "15 to 30 ", formula: "{Products.UnitPrice} >= 15 and {Products.UnitPrice} <= 30"
3. Formula name: "Over 30 ", formula: "{Products.UnitPrice} > 30"

Move the elements with the up and down buttons to match the correct order.
On tab "Data" set as "Show value" the average of units on order.

On the right side of the Dialog you can choose what should be done with values (unselected fields) that don't fall into any of the specified groups (the 'Others')

Select this option if you do not want to print the 'Others' in the groups for your report.

Your specified groups will be shown in the order you specified. Unselected groups are
displayed normally.

Select this option and enter a name if you want to put all unselected fields in one group. The default name
for this group is "Other".

• Chart Datatab
• Chart Sort Order