Searching and Sorting
Searching
To search within the results:
- Right-click on any column header and select Show Search Panel.
- A Search text box is displayed on top of the report. It allows you to search for terms or phrases within the report. Enter your search term or phrase here.
- The Search acts like a combination search and filter. Only rows containing the search term are visible.
Sorting a single column
The current sort order is indicated by the Up or Down triangle in the column header. If a triangle does not appear in the column header, it would mean that no explicit sorting has been applied.
To sort: Click once in the column-header (avoiding the column’s “filter” icon). If there is no sorting triangle already in the column header, data are sorted in ascending order. If there is a sorting-triangle present, the sort direction is reversed.
In the example below, you can see that the sort "CUSTNAME" has been changed from ascending to descending.
Sorting multiple columns simultaneously
Press (and hold) the Shift key on the keyboard.
With the Shift key down, click on one or more column headers If a header hsa no triangle, the initial sort is ascending. If there is a triangle, the sorting direction will be reversed. The sorting is based on the order in which you shift-click the columns. The sorting indicator includes a number showing you the order in which the columns are sorted.
The screenshot below shows a report sorted on three columns: first by VendorID, then by Class, and finally by Company.
Note: If you click a column-header without holding the SHIFT key, then any existing multiple-column sort is lost, and the data are sorted only by the clicked column (as described above in the section “Sorting a single column”).
Removing a Sort
To remove all multi-column sorting (and replace it with a single-column sort), simply click a column-header (without SHIFT). This will sort your data only by that column.
To remove the sorting from a specific column, right-click the column-header and choose Clear Sort from the context menu.
Related Articles
Sorting and Grouping
Sorting Pivot reports sort based on the arrangement of your row-area and column-area fields. To change the order in which columns are sorted, simply rearrange your report. For more information on how to do this, see the topic “Rearranging fields” ...Right-Click Menus
Right-click on a column header Sort Ascending - Sorts the column data in ascending order. See Searching and Sorting. Sort Descending - Sorts the column data in descending order. See Searching and Sorting. Clear Sorting - Removes sorting from ...Right-Click Menus
Right-click a filter-area icon Hide this Field - Removes the field. (To get it back, see the Field List below.) Order - Moves the field to a different location in the same area: Move to Beginning - Moves the field to the beginning of the list. Move ...Report List
The Report List contains all the reports available to you. You can change its appearance in several ways. You can change how the list is presented To change the list appearance, use the small icons above the search box. Icon Description The pin ...Sorts
Like many applications (Excel, for example), Mercury allows users to sort data. But sometimes you might want to sort not by the actual data-value, but some other way. Example: Suppose the field Size contains text values (S, M, L, XL) that correspond ...