Author Topic: Applying different filters to multiple columns  (Read 38 times)

Offline Sunil Sharma

  • Associate
  • **
  • Join Date: Apr 2019
  • Posts: 1
  • Forum Citizenship: +0/-0
Applying different filters to multiple columns
« on: 15 Apr 2019 05:41:03 am »
Hi

I am fairly new to Cognos and am trying to organize data a certain way.

I was hoping somebody could help me with applying different filters to each column.

If you refer to the attachment for each column I would like to apply a separate filter. Currently when I add a filter (which is a search by word 'contains') it adds everything together.

For example in column 1 I would like it to contain all searches for contractors containing the word 'carpet' and for column 2 all contractors containing the word 'glass'. However what currently happens is when I add filters it searches for all contractors containing the word 'carpet' and 'glass' across all columns.

Hoping someone can let me know where I am going wrong.

Thanks.


 


       
Twittear