COGNOiSe.com - The IBM Cognos Community

Hi,

I have a list report with series of columns for months Jan - Dec(calculated).

Report ID                Report Name             Jan             Feb           Mar            Apr.... etc      Total Counts
0001                       TEST01                        5
0001                       TEST01                                          7
0001                       TEST01                                                                             4
0001                       TEST01                                                          3

As you can see, the counts for every months for one unique report ID and Report name were displayed in 4 rows.

What I need to achieve is to display the counts for every months in a single row only and counts the total.

Report ID                Report Name             Jan             Feb           Mar            Apr.... etc      Total Counts
0001                       TEST01                        5                7                3               4                       19

Thanks in advance...

Have you checked the query formed? What is the aggregate functions of the calculated dataitem?

I already figured it out and it works by using unions.. Thanks!!!