Print Page - Aggregation calculated from two lists

Title: Aggregation calculated from two lists
Post by: hu on 29 Mar 2013 05:12:45 PM

Hi,
I am new to Cognos, I've already spent quite some time on this but still couldn't figure out how to do the following at ONE page of my report. will really appreciate if someone has a quick answer. I have Cognos 10.1

1. List1 (bind to Query1) has 2 columns,

ID | dataCol1
---------------
id#1 | numeric_value11

2. List2 (on the same page, bind to Query2) has 2 columns

ID | dataCol2
id#1 | numeric_value21

3. Then I want to show sum of data column from the 2 lists/queries for this same id, right below. Sth like

| Total
---------------
id#1 | (numeric_value11+numeric_value21)

Is a way to do so?

Thanks a bunch for any suggestions
hu

Title: Re: Aggregation calculated from two lists
Post by: blom0344 on 30 Mar 2013 03:23:04 PM

You can join Cognos queries locally and from the resultset (3rd query ) you can define the list with the calculation you are after.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: hu on 29 Mar 2013 05:12:45 PM