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
- 6443 Views
- Patni, I also Faced
- E-Mail Answers
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 slice and dice?
What is set to be cardinality?
What do you understand by the term 'model durability'?
Can you define a query subject?
How can I change reports to another package???
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......
What is a Pivot?
i would like enter some empty space after every 3 rows how is it possible....?
How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)
Hi,please suggest me how to creat username while creating a report.
give me scenario on cascading prompts&master-detail relation
Teradata 
