The Filter button (Ctrl + Shift + F) on the function menu and the context menu opens the filter window. Here you can choose to create a standard filter or an advanced filter via the field at the top of the window. In a standard filter you enter value intervals in the available columns in the list.

A standard filter can always be changed to an advanced filter (via the selector in the window). But for an advanced filter it is in most cases not possible to change to a standard filter.

In an advanced filter there is an editor where you can create advanced filtering of values with the help of Boolean operators and terms. The filter term is based on a structure which starts with And. It means that all underlying terms must be fulfilled for the filter to get a match. If you instead choose Or in the start mode, then it is sufficient that one of the underlying terms is fulfilled.

Example: You want either the term "Price each" to be fulfilled or the term "Amount" to be fulfilled or the term "Remaining" to be fulfilled. Then you create the filter with Or as a start according to the illustration.

Explanation of the term in the image: Remaining is greater than 1,000.00 OR Price each is greater than 200.00 AND Amount is greater than 30,000.00.

Explanation of functions in advanced filter

For each Boolean operator there is a menu where you can change between And, Or, And not, and Or not. You can also choose to add a term or group from that menu. A group is an underlying section containing a Boolean operator and its underlying terms. By using groups you can create complex nested terms.

Menu on Boolean operator.

You can also add terms using the plus sign in the editor, or by using the Insert key or Plus key on the keyboard.

Add terms using the plus sign, Insert or the plus key.

You create a term from a column from the gross list to the selected list type. Click the square brackets "[]" which initiate the term.

Gross list of columns for the list type.

Starts with is included by default in the term but you can select among many different options.

Selectable alternatives in terms.

You then enter the value for the selected column in the term.

The value in the term.

Instead of entering a value you can in the term choose to compare the value in the selected column with a value in another column. Then click the pen symbol.

You then click the column link and select column to compare with the columns from the gross list.

On the function menu in the filtering window there are a few buttons which are described below.

• Manage filters – Here you load saved filters, edit filters, or delete filters.
• Save the filter currently in use – Here you save the filter entered in the filtering window, either to a new filter for which you get to enter a name, or you can choose to replace an existing filter.
• Add row – With this button you add (copy) the marked filtering row. This only applies to standard filters.
• Delete selected row – With this button you delete the marked filtering row. Only applies to rows which you have added in standard filters.
• Clear filter – This will only clear the filter entered in the filtering window. If you have loaded a saved filter, this will still be available.

Under the filter button in column headings you can search and filter by values in the column. See an image below of this column filter.

You can quick filter the value in the column on the marked row. To quick filter you right-click in the list and hold the mouse pointer over the option Filter by xxxxxxx using value "yy" on the context menu. Then you select one of the different terms available on the sub-menu. See an image below of this quick filter.