How can I resolve calc context from diferents queries?
I have a dubt on a web Intelligence report about sum calc with dimensions from different queries. Let me give you an example.
Imagine we have from one query A:
And from query B:
We have City as merge dimension
And we need this result on the report:
The formula that I would writte to resolve it would be:
=Sum([Revenue] In ([City])) In ([Country])
But as we don't have the dimension Country on the query A I get 900 for all countries.
Can you help me to resolve that?,