If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Totals for each employee

Started by Natali, 13 Jan 2009 11:37:04 AM

Previous topic - Next topic

Natali

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

blom0344

1. apply grouping.
2. add total for the facts

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

CCSlice

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.