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
- 6341 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
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
Explain what is the main advantage of impromptu over cognos reportnet?
How create measures and demensions?
How to test a cube?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What are the different uses of a repository manager?
Define cognos report net?
what is the difference between list report and crosstab report?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What is difference between data mart and data warehouse?
What are the types of security?
What is set to be Cognos configuration?
What you mean by drill across?
What is called Cognos powerplay?
