Computing The Group Totals

[JoennAquilino]

Hello,

 

Is it possible to compute the group totals when collapsed(the aggregated total)? I have this calculated fields but it only calculates when the group is expanded. I want to calculate the values of them when it's collapsed, too.

 

Thank you.

 

Example

Collased data here(total) ||Collased data here2(total)||Calculated

2000________________||1000_________________||3000

 

Something like that?

 

[codell]

Hello Joenn,

 

If you would like to calculate aggregate values of a collapsed group, you can absolutely do so. Just open the "Advanced" tab on your Aggregate element in the datapage wizard. You can change what kind of group aggregation you want to show (None, First Group, All Groups) in the Group Options section. 

 

You can find more information in this article.

 

Does this help to answer your question?

 

COdell

[JoennAquilino]

What I want is, I have all groups be totalled. However I want to compute the total of each group.

[svitlanataran]

Hi Joenn,

Sure, it's possible. You should use calculated field in Aggregation.  

 

Add "Totals and aggregation" and select a calculated field.

On the "Advanced" tab select "All groups" for "Group-level aggregation"