COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Natali on 13 Jan 2009 11:37:04 AM

Title: Totals for each employee
Post by: Natali on 13 Jan 2009 11:37:04 AM
I have such a basic question that I am embarrassed, but the books we have are terrible, so here goes.

In a list report, how do I get subtotals for each employee?  I have a report that lists activity by employee, but now I want to print totals and counts for each one of the employees and a grand total at the end.

Can anyone give me a quick answer?   Thanks much,     John
Title: Re: Totals for each employee
Post by: blom0344 on 13 Jan 2009 12:46:45 PM
1. apply grouping.
2. add total for the facts

Both can be applied from the menu through the appropriate buttons.
Title: Re: Totals for each employee
Post by: CCSlice on 19 Mar 2009 01:41:50 PM
Quote from: blom0344 on 13 Jan 2009 12:46:45 PM
1. apply grouping.
2. add total for the facts

Both can be applied from the menu through the appropriate buttons.

Blom, does this apply to the report and the list object?  Can this be achieved within the query itself?   If I want the query to return totals for each employee can this be done?  Let me know your thoughts.