COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pucovsky on 17 Mar 2011 07:49:21 AM

Title: Total of Averages
Post by: pucovsky on 17 Mar 2011 07:49:21 AM
Hi

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

I need a list like this:


...............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.
Title: Re: Total of Averages
Post by: pucovsky on 17 Mar 2011 10:31:12 AM
Thanks to all.
I found this simple solution:

a new calculated/calculated data item with

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

definition.