If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Adding total value from two lists in one field

Started by rkas, 27 May 2021 03:55:54 PM

Previous topic - Next topic

rkas

Hi,

I have two lists on my report. Each list has total value. Each list has his own query
I'd like to sum total values from theses two lists and put in one additional field.
How can I do it ?

Regards,
Rafal

dougp

I assume what you mean by "one additional field" is a singleton somewhere on the page, outside of both lists.

simple brute force:

query1:
dimension1
dimension2
sum of measure1

query2:
dimension3
sum of measure2

query3:
sum of [query1].[measure1]

query4:
sum of [query2].[measure2]

query5:
sum of [query3 union all query4].[measure]

rkas

I mean that field outside of both lists.
I try to put this field into table and use query calculation but the system does not allow to use two different query for one field.
I must admit that your answer is not clear for me.