Home  >  Blog  >   IBM Cognos  > 

What is Group Filter in Cognos

Rating: 5

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:


Frequently Asked Cognos Interview Questions & Answers


Join our newsletter

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
IBM Cognos TrainingApr 01 to Apr 16
IBM Cognos TrainingApr 04 to Apr 19
IBM Cognos TrainingApr 08 to Apr 23
IBM Cognos TrainingApr 11 to Apr 26
Last updated: 30 March 2023
About Author
Remy Sharp
Ravindra Savaram

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.

Recommended Courses

1 /15