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