Hi, community.
Could you land me you hand, please?
Environmental:
-DMR model.
-Report Studio 8.4
Task:
I have products sold by price > 100$ and <0$ in different countries.
I'd like to show within Crosstab:
GEO and amount of products sold by price > 100$ and <0$ as three columns.
My solution:
- I create Query2 with "GEO", "amount of products" and filter for products sold by price > 100$, "0" as value for column (calculated measure) that show products sold by price <= 100$,
- I create Query3 with "GEO", , "0" as value for column (calculated measure) that show products sold by price > 100$, "amount of products" and filter for products sold by price <= 100$
- I create UNION as Query 1
Trouble:
- The list is working perfect
- the crosstab doesn't want to work and error occurs
Error:
RQP-DEF-0502 Master dataset can not be used for the provided query Query2 as they do not match. RQP-DEF-0149 The query specification is incorrect. RQP-DEF-0457 Referenced Query 'Query1_tab' is not defined or its query items contain unresolved references.
Any help appreciated.