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
- 6436 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / lakshmi reddy
select avg(depttotal) from (select sum(sal) as depttotal
from emp group by deptno)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
-------------What is Coditional Prompting?
9. What was the most complex type of report you dealt with?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What is the difference between the content store and content manager?
What is Bitmap Index?
Why are meta service important then other services?
How to create model and how to test model?
How do you Parametermap variables in Quiries?
What is the advantage of using shortcuts?
How do you improve the performance of the Cognos Analytics report
What is the difference between a cascading report and drill through the report?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
how you migrate reports to cognos 8 from previous versions?
