Skip to Content
0
Former Member
Mar 14, 2016 at 01:11 PM

Merging 3 queries using 2 merged dimensions

463 Views

Dear experts,

I need to create 1 report using 3 queries.

Problem is that Query 1 and Query 2 do not have common dimension to merge with.


As a solution, I merged it like that using 2 merged dimensions.

(Query 1 + Query 2) + (Query 2 + Query 3)

I have a problem when I try to sum column in Query 3.

I get #context error.

I am not sure if I should use In ([ID]) or, In (mobile#)

Because 3 of the tables are merged into one...


I would be extremely grateful if you could advise on this method...

Attachments

merging.png (17.9 kB)