When preparing the summary view, buttons for transitioning to the summary view are prepared on the search screen.(Figure 1)
Fig. 2 shows an example of sales summary and graph display by department.The graph is provided at the bottom of the summary view.
We prepare two models "department" and "sales aggregation".(Figure 2)
The division model is an option model.We prepare three types of "sales part", "sales part 2", "sales part 3 part".(Figure 3)
Figure 4 shows the definition of the sales aggregation model.Dimension is "department" item.Major is "sales amount" item.
You configure a compound key with two items "department" and "year/month".For department items, refer to the department model shown in Fig.Set sorting rules in ascending order of ID.(FIG. 5, FIG. 6)
Also set "year/month" item as primary key.(FIG. 7)
The input method of "year/month" item is set as list box (year/month).Also, set the initial value as "Today's date" (TODAY function).(FIG. 8, FIG. 9)
Set the output format of "Sales amount" item.(FIG. 10)
Open "Screen> View> Summary View".Multiple aggregate views can be prepared.Here we define the summary view of number 1.
Check "Create screen" and set the page title.Dimension 1 specifies department fields.
In addition, specify graph output.In this example, we will define the type as "collective column chart" and specify the color, height and width, respectively.In addition, the vertical axis is the only total.
Click the "Major" button and designate the sales summary item as major.
An example of setting search conditions to automatically calculate "this year" (from the beginning of April until the end of March of the following year) for "year/month" included in search conditions is shown below.
For numeric and date types, range search is enabled by default.So we set two expressions in the search condition.Each will be the beginning (from) and the end (to).
You can display the ratio in the total column.(FIG. 18)
Activate "Display Ratio" prepared for definition of summary view.(Fig. 19)
Numeric format can be set for ratio.If unspecified, it is handled the same as '(' The following example is valid for up to two decimal places.