SSAS MDX Query The following is the database configuration:

Supplier(Supp_ID, Name, City, State)

Consumer(Con_ID, Name, City, State) P

roduct(Prod_ID, Name, Product_Category, Product_Line, Product_Packaging)

Offers(Supp_ID, Prod_ID, Quantity, Price)

Requests(Con_ID, Prod_ID, Quantity, Price)

Transactions(Tran_ID, Supp_ID, Con_ID, Prod_ID, Quantity, Price)

Measures only come from the Transactions table and are the following: Price, Quantity, and Count

I am asked to do the following:

For each product list quantity sold by suppliers in Madison to consumers in Chicago versus quantity sold by suppliers in Chicago to consumers in Madison (result columns will be: product name, quantity Madison_Chicago, quantity Chicago_Madison?

I cannot seem to figure out how to join the two MDX queries that answer the question and alias the columns.