You can specify total, number, average, maximum, minimum, product, center, frequency, standard deviation, and variance for each measure.
You can specify various calculation methods for each measure.Figure 1 shows an example of aggregation with alternating sums and averages.
Define the items to be specified as measures.(This time it is all numerical type.)
Open "Screen> View> Summary View".Activate "Create Screen".
"Page Title" is also used as a button name for transitioning to the tabulation view.When it is blank, the button name becomes "Totalized view 1", so please set the page title as much as possible.
Set the items in the "dimension" column.For this time, we specify two dimensions of "store name" and "data".
In Figure 4, press the "major" button and specify which item to use as a measure.(FIG. 5)
Here, total or average is specified for each item.
In the numeric type field, you can specify one of the following as the aggregation method.