Determine table based on prompt

Thank you Marfi for your solution.
The company wanted an easier solution so I could not reply so far:(

I am trying your solution. I build a combined query. Each query has one dimension and two measure objects. Two measure objects are being calculated in two different contexes. So when I try to union these two queries, I am getting the error message below:

“This combined query cannot run because one of the queries contains incompatible objects.”

Are there any solution for combining queries which involves two or more sessions?

https://bobj-board.org/t/31425
I looked at this post, as I saw it is not possible but I am not sure.
Do you have any idea?

Thanks.


user3756 :turkey: (BOB member since 2012-06-01)