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

Modified on Mon, 04 Mar 2024 at 04: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.



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.



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



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 atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article