Sort, Filter and Group Data in Tables

Many tables in the MineMarket user interface have sortable columns. For these tables, you can click the column name to sort the data in ascending or descending order. If you want to sort by multiple columns, press and hold Ctrl while clicking the required columns. A small numeral next to the arrow in the column header indicates in which order the columns are sorted.

Some tables have a grey bar at the top with Drag a column here to group by that column. If you drag a column name to that text, MineMarket groups the data in the table. You can group data by multiple columns if required. In these tables, if you want to sort by multiple columns, press and hold Ctrl while clicking the required columns. A small numeral next to the arrow in the column header indicates in which order the columns are sorted.

Some tables have a Filter Filter icon icon next to each column name. You can filter data in these tables in a similar manner to filtering data in Microsoft Excel or other spreadsheet applications. You can enter advanced filters, and combine multiple filters in the Custom AutoFilter dialog box, which displays if you select a filter that has an ellipsis (...) in the filter name. You can filter multiple columns if required. Filtered columns have a yellow dot on the filter icon. Filtering functionality is available in these screens:

Activity Steps

  1. To sort or filter a column of text:
    1. Click the filter icon next to the column name.
    2. Select a sort order or filter:
      • Sort A to Z
      • Sort Z to A
      • Text Filters—Enter advanced filtering, such as equals a specified text, or contains specified text.
      • A list of text strings that are in the column, with checkboxes that can be selected and cleared. You can enter text in the search field above the list to limit the values displayed in the list.
  2. To sort or filter a column of numbers:
    1. Click the filter icon next to the column name.
    2. Select a sort order or filter:
      • Sort Smallest to Largest
      • Sort Largest to Smallest
      • Number Filters—Select a predefined filter, such as Top 10 or Above Average; or enter more advanced filtering, such as greater than a specified number or between two specified numbers.
      • A list of numerical values that are in the column, with checkboxes that can be selected and cleared. You can enter a number in the search field above the list to limit the values displayed in the list.
  3. To sort or filter a column of dates:
    1. Click the filter icon next to the column name.
    2. Select a sort order or filter:
      • Sort Oldest to Newest
      • Sort Newest to Oldest
      • Date Filters—Select a predefined date range, such as Yesterday, This Week, Next Quarter or Year to Date; or enter more advanced filtering, such as after a selected date.
      • A tree view of dates that are in the column, with checkboxes that can be selected and cleared for years, months and days.
  4. To clear filtering from a column:
    1. Click the filter icon next to the column name.
    2. Select Clear Filter From [Column Name].