Pivot Table

Result grid is the easiest and most versatile output type, it may be interesting to present the data in a synthetic form using a pivot table or pivot chart.

When you are on result grid, you can access the pivot table/chart tool using the icon in red box below.

This is where you choose the numerical data to be displayed: sum, average, number of records, etc.

Depending on the type of aggregation chosen, zero, one or two fields can be specified as parameters.

Regardless of the field area chosen, and as long as you don't have too many different values for this field, you can filter the values to be taken into account here: