Picking up totals from separate queries

[Toze]

hi all.

I have two different lists with separate queries on report. There's no joins between the queries. Now the customer wants to see the difference percentage of these two separate totals ( don't ask why...). So, is it possible to pick the total values of both lists and make the simple percentage calculation from them?

[dfite]

I have a similar report requirement, Toze.  Did you ever figure this out?  When you try to sum the totals up, do you get a "cross joins not allowed" error or something?

[Suraj]

Look at layout calculation, if that doesn't help:
You have to create a 3rd query that joins the other two and then perform the calculation as you'll have access to data from both queries.

[imts]

@Dfite - U can remove that "cross joins not allowed" error by selection YES in the "Cross Join Allowed" property of the query .. But it wont give u correct answer in your case . As it will make all possible combination (NxN join).

@Toze,Dfite - U can create a third qury having just the measures that u want the totals of and put an INNER JOIN cluase on it using a common dimension. when u get the data in this query then u can manipulate it to get desired results.