How to show the Group Average (Total value / Group count) in the summary 


Group Average (Total value / Group count) displays the average of all the values within the same group. The group average summary will be applied on the front-end object view data.


The below sales cross-tab shows the gross sales of Product categories and their products over different years. To display the total average sales of each category, follow the below steps.

image001.png

SALES CROSS-TAB

Step 1

In the  cross-tab, right click on any Product, the system displays the menu.

Step 2

In the menu, select Summary and Settings. The system displays the Summary dialog box.

Select 'Group Average' from the drop-down list and click OK.

image002.png

SUMMARY DIALOG

The average sales of all the products under different categories will be displayed as below.

image003.png

SALES CROSS-TAB SHOWING GROUP AVERAGE SALES

As highlighted in the sales analysis, the average value '898,312' is calculated as the total sales (Beer + Whisky + Wine) / Total count. ie; (767,387 + 1,419,927 + 507,622) / 3


Note: This article is based on ElegantJ BI Version 4.0. This may or may not be relevant to the ElegantJ BI version