Starfish2201
Programmer
Hi,
I have a requirement in which I need to have 2 sets of data in a list report. To be specific, I have 8 columns in the list, first 4 columns will have the data for the entire table, rest 4 columns will be of a subset of the whole data. e.g. if first 4 will have counts or some calculated values of all the ADDRESS, the 2nd 4 columns will have counts/calculated values for the "ADDRESS NOT HAVING A ZIP CODE".
Can anyone please let me know how I can do this? If I am applying filter for last columns, I would miss the records for the first 4 columns.
I am very new to Cognos, any help will be really appreciated.
Thanks in advance !!!
I have a requirement in which I need to have 2 sets of data in a list report. To be specific, I have 8 columns in the list, first 4 columns will have the data for the entire table, rest 4 columns will be of a subset of the whole data. e.g. if first 4 will have counts or some calculated values of all the ADDRESS, the 2nd 4 columns will have counts/calculated values for the "ADDRESS NOT HAVING A ZIP CODE".
Can anyone please let me know how I can do this? If I am applying filter for last columns, I would miss the records for the first 4 columns.
I am very new to Cognos, any help will be really appreciated.
Thanks in advance !!!