Total of Averages

[pucovsky]

Hi

This is something that has probably a simple solution (but unfortunately I don't know it):

I need a list like this:

Code Select Expand


...............col     
detail1........10
detail2........20
group1---------15    .......(average)
detail3........20
detail4........30
detail5........55
group2---------35    .......(average)
-----------------
total          50


I have defined group summary with aggregate = Calculated and rollup = Average.
How to define list summary to get total of those two group averages?

Thx.

[pucovsky]

Thanks to all.
I found this simple solution:

a new calculated/calculated data item with

total( average( [col] for  [group] ))

definition.