Pivot table with Filter

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

Tutorials in the same category

Tutorial: Saving Report Views

In this example, we will see the options available for the end user to store, in session or in a...

Tutorial: Grid with modal filter.

This tutorial will show how to configure a query filter to display in a modal window, using the res...

Export Option

To export different types of files we must carry out the following steps: 1 - Create a Grid ...

Integration with WhatsApp

To integrate WhatsApp with ScriptCase, we will be using a specific API called Chat-API, it is a...

Comment this post