The 2 containers can be merged using master details relationship
The 2 containers should have a common query item to merge the data
Add the following query items to the list
Staff name
Order number
Order date
Revenue
From toolbox,
Drag the list drop beside the revenue
Add the following query items to the list2
Order number
Product name
Description
Quantity
From List2,
Select order number
From the toolbar click on the cut
From list2,
Select quantity
From the data menu,
Select aggregate
Click on total
From data menu
Select Master-Detail relationship
Click on a new link
From list2
Select quantity
From data menu
Select aggregate
Click on total
From data menu
Select Master Detail relationship
Click on a new link
From query1
Select order number
From query2
Select staff name
From structure menu
Click on Group
From structure menu
Select Headers & Footers
Click on create headers
Select the staff name header cell
From toolbar, click on delete
Edit the fonts
Run the report
Enroll for Instructor Led Live Learn Cognos Course
Related Articles:
Cognos Interview Questions and Answers
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Name | Dates | |
---|---|---|
IBM Cognos Training | Jun 03 to Jun 18 | |
IBM Cognos Training | Jun 06 to Jun 21 | |
IBM Cognos Training | Jun 10 to Jun 25 | |
IBM Cognos Training | Jun 13 to Jun 28 |
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.
1 /15
Copyright © 2013 - 2023 MindMajix Technologies