COGNOiSe.com - The IBM Cognos Community

I have a list of ~1,500 values, like this:

LocationId  ActionCount  % of Total
1234          0                     0
5432          0                     0
9875          5                     7.4%
6657          3                     4.2%

I know that I can filter the output in the query itself (% of Total = 0), but I'm wondering:
1.) CAN I filter values by filtering in/on the list object itself?
2.) Can I create a variable that would achieve this? Would I want to?

I have experience with WebI, where it is very easy to create variables that then modify your dynamic 'queries'. I've found Cognos to be less clear in this way, and the IBM documentation sucks.

Thanks for your input

Hi,
You cannot filter on the List itself you have to do this at the query level. One option is to have the prompts on the list page itself.
Good luck
New guy

That is not entirely correct.

If you choose to create an active report rather than a static report, List objects in that can be dynamically filtered through freely definable report interaction.