Home  >  Blog  >   IBM Cognos

What is Group Filter in Cognos

Rating: 5
  
 
4072

A filter limits the information Cognos will retrieve for your report.

In general, you should always filter your report to ensure that it contains exactly the information you need. Often, you will want need many filters. Information must match all filters for it to appear on your report.

Enroll for Instructor Led Live Cognos Training Online

Group Filter:

Group Filter: Applies a filter to groups in the report. Generally appears in the query of query explorer.

You can filter information at a higher level by using the Group Filters tab in the Filters window. When you apply a group filter to a report item say, Product type, product types that do not fit your specification are filtered out when you run the report.

  • A filter which applies to the group is known as group filter
  • Add the following items to the list
  • Product line
  • Product type
  • Quantity
  • Define group on Product line
  • Define total on quantity
  • From the menu bar, select data
  • Select filters
  • Select the edit filters
  • Select summary filter
  • Click on add
  • Select the radio button Custom based on data item Quantity
  • Click on OK
  • Select the operator >
  • Type the value 100000
  • Click on OK
  • Run the report
  • In the report, we can see Golf Equipment Total 99400
  • Now select Edit filters
  • Select Summary Filter
  • Select the scope value as Product line
  • Click on OK
  • Run the report
  • Now in the report, we can not see Golf Equipment

MindMajix Youtube Channel

Explore Cognos Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

Group Filter:

Blog post image
Blog post image
Blog post image
Blog post image
Blog post image

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
IBM Cognos TrainingMar 05 to Mar 20View Details
IBM Cognos TrainingMar 09 to Mar 24View Details
IBM Cognos TrainingMar 12 to Mar 27View Details
IBM Cognos TrainingMar 16 to Mar 31View Details
Last updated: 28 Apr 2023
About Author

Ravindra Savaram is a Technical 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.

read more
Recommended Courses

1 / 15