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
- 6208 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 dimensions that you have in your current project?list them?
What are the different types of reports present in cognos?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Define olap designer?
Can you define slice?
How to create a cube in Transformer? What is the process? Please mention process thank u
what is the procedure for scheduling conditional rendering?
Can you define folder?
What r the names of the reports that you prepared?
----------------Diff b/w Dimensional modeling and Relational modeling?
which type of project we r going to snowflake schema
What are all the types of report?
What is called cognos reporting tool?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
4. How many dimensions did you use in your reports?
