Using Grouped Totals as a Single Field

[emt3245]

I have report that is grouped by academic subject then professor then professors salary along with courses taught by term:
American Studies  John Smith    $50,000      AS 1000-001     5
                                                                 AS 1000-002     10
Total                                                                                  15
                            Mary Jones    $40,000      AS 2000-001     1
                                                                 AS 2000-002     9
Total                                                                                  10
Total                                         $90,000                             25

That is how it should look but it is doubling the salary because technically the salary is on all the lines we are just grouping so it appears once.  How do I get the salary to total only once as opposed to however many lines there are.

[tjohnson3050]

Try changing the salary data item to a calculation that averages the salary records for the professor:

average([salary] for [professor])

Getting familiar with the 'for' argument increase your Cognos skills exponentially:

     ftp://public.dhe.ibm.com/software/dw/dm/cognos/reporting/advanced_report_design/using_the_at_and_for_options_with_relational_summary_functions.pdf