New Range Grouping Rule Dialog Box Options

Use range grouping rules to organize data based on ranges in a particular field. The interval of each range is considered a group. A range group is used with numeric or date fields. For example, you can define coupon ranges as Low (0–6) Medium (6–9) and High (above 9). Set up range details by completing the options on the New Range Grouping dialog box.

Option

Description

Field Details

Enter Trade Date as the field name.

Operator

Select an operator:

  • > and <=

  • >= and <

  • > and <

  • >= and <=

  • > or >=

  • < or <=

  • !=

  • =

Group by

Select this checkbox to group by month/year.

Grouping Method

Select Month-Year.