Custom column filters

After you run your report, you can click a column title to use the custom filters. With this tool, you can limit the amount of items on the page by filtering on a specific column, sort a column in ascending or descending order, select columns as the X or Y axis for a graph, or hide any column in the report.

1. Click a column title.
2. Click Apply custom filters . The Custom Column Filtering dialog box opens.
3. Select an item from the list.

There are different drop-down lists depending on the type of data in the column: Text, Numeric, and Date.

1. In the text box—depending on the type of dialog box—do one of the following:

Text dialog box

Type a string using the wildcard (%), for example:

1. 1. - Grad%: Starting with Grad.
    - %proposal: Ending with proposal.
    - %Research%: Research anywhere.

Numeric dialog box

Type a number.

Date dialog box

Add the date using one of these options:

1. 1. - Click the calendar.
    - Type it in this format: dd/mm/yy.
1. Click Apply Filters. Records matching the filter criteria open.
2. You can do one of the following:
1. Repeat Steps 2 to 5 to filter your report further.
2. Click the column heading and then click to Remove custom filtering for this column.

1. Click a column title.
2. Click one of the following:
3. Sort Ascending.
- Sort Descending.

An up or down arrow displays beside the column title.

1. Click the column heading and then to Remove Sorting for the column.

Click the column title you are using for your X Axis and click . The symbol displays next to the title.
Click the column title you are using for your Y Axis (must be numeric) and click . The symbol displays next to the title.

Click a column title.
Click to Hide this column.
To show the column, click the Report Options tool bar and then Advanced Options.
Under Display, select the check box for the column.
Click Execute Report.