Picked Range

New Range

When a Data Table is open and the window has focus, you can set up the ranges that will be used to filter your table data.

  1. On the Home tab, in the Settings group, click the ellipsis [...] button to the right of the Range selection drop-down:

  1. To create a new Picked Range, in the Setup Ranges window, right-click on the Ranges node (or a folder) and select Add | New Picked Range.

The Text and Picked Ranges that have already been created are listed on the Ranges tab of the Select Range dialog. Icons help identify the type of range:

Icon Range
Picked
Text

An Expression Filter allows for an alternate or additional filtering process to apply to Picked, Ranges From Field Values and Text Ranges. The Expression should result in a True or False (an IF statement is not necessarily required).

Note: Both filters can be considered as inclusive, allowing data through. You must select at least one Node in the Node Filter, but you only need to select Positions in the Level Filter if the Level Name is selected. For example, "Bench" in the example below:

Inverse ranges allow you to set a range that includes everything BUT what is picked. Useful for selective exclusion.

See also: Ranges from Field Values