Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Studio: Total of Averages

Status
Not open for further replies.

pucovsky

Programmer
Feb 16, 2011
8
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.
 
Thanks to all.
I found this simple solution:

a new calculated/calculated data item with

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

definition.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top