Hi
I have 3 different queries.
Query 1:Group2,Group1,units and dollars
Query 2:Group2,Group1,units dollars
Query 3:Group2,Group1,units dollars
I want to join all the 3 queries in 1 query as I need all the 6 measures (Units and dollars from 3 different queries in one query)
For query 2 and query 3 queries,There are 2 separate query subjects in the package and I have Item code but the item code that exists in 2 need not necessarily should exist in 3.
For query 1,there is other query subject in the package and there is no item code in this query subject.
Now i need to include all the 6 measures (units and dollars) in one query as i need to do some calculations on the measures.
Can anybody explain in detail how is it possible to achieve
Why don't you use the union element from the insertable objects pane "toolbox"?