I need to create a report in the follwing format Customer CustomerGroup1 CustomerGrp 2Custome Total C3C5TotalC8C10C11 Amount I am very new to MDX. The customer dimension has the members c1,c2,c3, c4,c5,c6,c7,c9,10............ Measures.Amount. I need to create 2 columns from the customer dimension and have totals for both group .(Trying to create a grouping for customer) I know I can have the reporting format with matrix, but how can I create 2 columns from the same dimension in MDX . I am looking for a solution at a query level just like we do in SQL. With my limited knowledge whatever I try, it will pull all the members to the same column. Does a union work . If so ,can some one guide me through. I would appreciate an immediate response. If nothing works at a query level, I have to request for adding another dimension/grouping. Thanks.