Skip to Content
0
Former Member
Feb 16, 2015 at 10:23 AM

Link the result from another query in another report.

85 Views

Hello hi,

I have a Web Intelligence document and inside this document, I have two reports from two queries.

So, query 1 generates report 1 and query 2 generates report 2. However somehow I need the total figures in report 1 to be part of the calculation in report 2.

For example, in report 1, there are three rows

A $1

+B $2

+C $3

= Report 1 total =$6

And in report 2, I have something like this

D $4

+ E $5

+ Report 1 total $6

= Report 2 total $15

Thanks.