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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / lakshmi reddy
select avg(depttotal) from (select sum(sal) as depttotal
from emp group by deptno)
Is This Answer Correct ? | 2 Yes | 2 No |
What are types of batch available in cognos?
2.How do you drill through report from Report Studio to Analysis studio?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
How will you migrate your reports to QA environment?
What is value prompt limitations while creating report? What is select and search prompt?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this
how you create security to cubes ?????
What is Online View?
what are determinants?
4 Answers College School Exams Tests, IBM,
Can you define transformer?
What is model filter and query filter?
what are diff b/w cognos and business objects