Group Average (Total value / Group count) in the summary

Modified on Mon, 4 Mar at 4:58 PM

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 Smarten Version 5.x. This may or may not be relevant to the Smarten version

Group average Total value / Group count front-end object average sales summary operations Business Intelligence Support Business Intelligence Articles Business Intelligence Training

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article