I have a report with 16 categories as columns; my database (Snowflake) records can apply to one or more of the columns.
Is there a Cognos pre-built way to filter out records from one column without entirely removing them from the report as I need them to be displayed in a different column? I am trying to avoid writing 16 separate queries if possible.
Example: Record 1: $100, Has Category_1 field = Yes Record 2: $50, has Category_2 field = Yes
Report will show Column: Category_1 | Category_2 Row: Amount
Category_1 should be filtered for YES and Category_2 filtered for YES as well. When I filter Category_1 is removes record 2 from the report and nothing is left to filter in Category_2 field