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
- 6348 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 |
can any one explain about blue prints&performance tuning in cognos?
I want to schedule the report as sysdate-1.....how to do
what is drill down and slicing and dicing what are the difference between them?
explain project, package ,model , modelers.........and differences b/w them?
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?
2 Answers ABC Infotech, Virtusa,
i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?
How to give a securites in object level&datalevel&pakege lavel in frame work manager?
What is the difference between Standard and Metrics folder?
what is the difference between list sequel and cross tab sequel?
How can I change reports to another package???
How to create multilingual reorts?
im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?
Teradata 
