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
- 5369 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
what are the features in cognos8ui
How can I test reports in cagonos?
What are the advantages of using cognos sql?
What is the difference between a data mart and a data warehouse?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
where you can save the report net documentation in our local system?
What do you understand by ‘ibm predictive maintenance and quality’?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What is defined as data mining?
What is the difference between static and dynamic conditions?
Can you explain model durability?
What are the types of studio?
What is the difference between low affinity and high affinity connections?
What are the two types of framework manager?
