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 ..!!
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
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.
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