Aggregation calculated from two lists

[hu]

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

[blom0344]

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