Skip to Content
avatar image
Former Member

Merging 3 queries using 2 merged dimensions

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

merging.png (17.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 14, 2016 at 01:43 PM

    Hi,

    Can you share a piece of your data from the 3 data providers ?

    Regards,

    Rogerio

    Add comment
    10|10000 characters needed characters exceeded