In this tutorial we will be making a summary with filter.

Creating a Grid

1 – Create an application of the Grid type.

2 – To enable the Summary in the grid, we must create a group by, then we will create it through the Menu “Group by> Static group> New Group by”.

3 – Select the fields as follows:

4 – We will also create dynamic group by, which allow the end user to choose the desired grouping.

 5 – We select the following fields:

6 – After creating the groupings, we must access the “ Group by ” settings to check some options, and configure them as follows

7 – To create the refined search in the grid, we must go to “Summary> Search> Fields”, and select the fields that will be part of the filter.

8 – Field settings can be edited using the “Edit” button next to each field.

8.1 – Date_1

8.2 – Date_2

8.3 – Region_1

8.4 – Sales_1

9 – Go back to the “Grid Modules” options and activate only “Grid” and “Summary”, and place “Summary” as the initial module.

10 – Save the changes and execute the application