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