Sorting on Multiple Columns - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

You can base the sort in a List View on the values in multiple columns. This is particularly useful when you have a long list, with duplicate values in some fields. For example, the List View may contain columns for Street Name, City, and State. It might be useful to sort the data first by state, then by city, and finally by street., so that rows that are geographically related are grouped together.

To sort on multiple columns

  1. Right-click any column label.
  2. Select Multi-Column Sort. The Multi-Column Sort window opens.

    Graphic of the multi-column sort window

  3. In the Sort Items By field, specify the following information for the primary sort key:
    • Column name
    • Direction (ascending or descending)
    • Type of sort: by default, the Control Center sorts by value; if you want to sort by data length, select the Sort by Length check box.
    • Uniqueness: Select the Unique check box if you want the list to display only rows that contain unique values in this column.
  4. Repeat step 3 for each Then by level of sort you want to apply.
  5. Click OK.