Interested to Buy Any Domain ? << Click Here >> for more details...
how to create average on totals of different departments
employees salary...? consider we have 3 dept and in each
dept 10-15 workers i need to get the totals separately for
each dept and average of there totals..help me pls
- 2 Answers
- 6435 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / chiru
Apart from SQL Queries... When we need to generate a report
as per above requirement, first of all drag and drop deptno
(lets assume having deptno=10, 20, 30), After that drag and
drop "workers" Query item.... After that apply grouping on
deptno Query Item.... If u apply grouping on deptno.. it
automatically gets totals of all workers group by deptno...
But as per our requirement go to cummary and apply total icon
on workers Query item...
after that again apply average option from summary on workers
Query Item...
Now u can get both average and summary for deptno wise.. i.e
when u run the report......
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Name the types of report?
What DB View and Bus View?
What is the model filter?
Define catalog in cognos and write its various types?
What is meant by Reportstudio shortcut?
What are cognos connection initial page components?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
Can you explain new content durability?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
how to perform back drill through in cognos 8 what is the use of it
What is the function of cognos dispatcher?
What are the ways to import data into catalog?
What is cognos connection?
Can you explain the advantage of using shortcuts?
