List Filter on single column

[aww91]

Hi,
I am new to Cognos 11 Reporting so please excuse the my lack of understanding. I want to filter a particular column in a list without impacting other lists that uses the same query. My background is BusinessObjects which has Query Filters and View Filters. Thanks in advance

[oscarca]

I am assuming this is relational data, then you could use a case/if-statement to accomplish this:

Create a Data item "USA" and write the following expression:

case
       when [Country] = 'USA'
       then  [Country]
       else null
end

If you want the Data item to filter based on a prompt selection then you could use a prompt macro:

Data item (Country Selection)
#prompt('pCountry', 'string','[Country column]')#

//Oscar

[aww91]

Interesting. So would the prompt affect the entire report or just the specific page?

[oscarca]

It will only affect the list/crosstab where you place the data item i.e not the whole report/page/query. It is like a dynamic data item filter.