How to show the total of two items from different list in third list.

[ankit.agg.2008]

Hi,

Consider the below scenerio where I am facing an issue to do the same.

Issue Description : Suppose there are 2 lists each with same columns having same data types. Both having totals of the fact columns. (suppose Amount)

Requirement : I want to show the sum of the Total (Amount from List1) and Total (Amount from List2) into a third list seperately having only the sum of the two.

Request you to kindly help on the same.

Thanks in advance ..!!

[Rahul Ganguli]

Hi Ankit,

You can use table and singleton to achieve this. Inside query you have to create a new data item which calculates total of facts for the report.
I have attached a sample report for your reference. Hope you have samples configured in your cognos environment.

Regards,
Rahul

[ankit.agg.2008]

Hi Rahul,

Thanks for your time.

I have tried the same way by using a table and then a singleton. But the values coming in the result is not coming correct.

[Rahul Ganguli]

Hi Ankit,

Have you seen the reprot xml I have attached with the previous post, is it working fine?
Can you send me your report xml so that I can have a look into it.

Regards,
Rahul