Sets the formatting of the fields displayed in the subtotal for the group. General SettingsДЄllows you to change the label displayed in the totals

This option allows you to configure the display of values and labels of the selected fields in the Grid totals. If selected it shows the fields in the same row or divided by line. This option sets the total fields display. This option displays the values in the left corner by positioning the results next to each other. In this example, we are displaying the sum, average, maximum and minimum of column Sales. It is possible to position the total lines by dragging to the desired position. The option Grouped returns the total result, separating each type per line. This option allow you to customize the total labels.ДЄs default we are going to display Grant total The alignment can be in the Center, Left e Right: This option is available for display formats Default and Grouped.Дefines the placement of the label selected within the Setting > Display total option. The line with General Total displaying the Sales. When you use the total for more than one column of the Grid, using the same type of summarization, the results are displayed on the same line. The option Default returns the result below the column being summarized. To add the same field two or more times in the Totals or use different types of summaries in selected fields, this option will not be displayed. There are three display formats, Default, Grouped or By field Default PositioningДefines the positioning and the label used by Grid totals. Important note: The fields in the Grid totals are displayed only on Grids with no Group by or with empty Group by.

Distinct Count : Displays the total number of records for the selected field, distinguishing the values.

Count : Displays the total number of records for the selected field.

In calculating the weighted average, each set value is multiplied by its вЂњweightвЂќ, that is its relative importance.

Weighted average weight : Field that will be used as weighted average weight.

To set the weight used in the calculation of the average access field settings selected in Totals > Fields (select the field where you are using the Weighted mean) > Weighted average weight.

Weighted mean (WAvg) : Calculates the weighted average for the selected field.

Standard Deviation : Measures the variability of values around the average, the minimum value of the standard deviation is 0 indicating that there is variability, i.e.

Variance : Calculates the dispersion of the values related to the average.

Average (Avg) : Calculates the arithmetic mean of the values for the selected field.

Minimum : Displays the lowest value identified in the selected field.

Maximum : Displays the highest value identified in the selected field.

Sum : Sets a sum of the values for the selected field.

When positioning the fields, you must define what summarization will be used, to select that you must click in the combo box and select one of the available options, that will be according to the data type (integer, date, textвЂ¦). Note: The total fields will only be displayed if they are also selected to be displayed within the Grid application module. To define the fields that will be used for totals, drag them to the area, Grid Totals. The same field can be used more than once in the Grid totals area, just if they are using different summaries types. Using the select fields area you can set the total fields ant the total options for each field.

Display - This option sets if the Group Subtotal it will be display.

Label - This field sets the Label for the Group Subtotal.

Setting of display of the subtotal group.

Example for this option Enabled: * Example for this option Disabled:.

Record Count : This option allows you to view the amount of records by the General Total title.

Group Subtotal : This option defines where the subtotal group by will be displayed.

The options are: On every page, On the last page or Do not display.

Display Total : This option indicates in which pages the General Total will be displayed.Results in a single line.: This option sets the display of the General Total title and its results in a single line.The settings below only can be applied for the Grid totals. The total fields will be displayed only when the Grid application is using at least one Group By.

Replace scriptcase icon