Download and import the attached configuration called 05. DOCX Output (Filtering, Sorting and Grouping) in Lasernet Developer 9. Afterwards, go to the Forms section and open the Sample form.

In the current exercise, you are proposed to filter data in the table, as well as sort available items and group them by a field.

1. In the input, switch to Sheet 1.

2. Click in any field of the table in the output. You can see the Filter tool is now active on the Developer toolbar. Click it.

3. In the Filter String Editor dialog displayed, click the plus button. It is automatically prompted to create a filter for the discount values. Let’s do it. To this end, type 5 in the <enter a value> field. Once you are done, click OK.

You can see data in the table filtered according to the criterion you have specified.

4. In the input, switch to Sheet 2.

5. In the output, right-click a value in the DISCOUNT column. In the context menu that appears, click Sort Descending.

You can see data in the table sorted by the discount in the descending order.

6. In the output, right-click a value in the DISCOUNT column. In the context menu that appears, click Group By Field.

You can see data in the table grouped by the DISCOUNT field.