Hello: I'm creating a SSRS 2008 R2 report with data from an SSAS cube. It's seems like a pretty simple report and here are the measures and attributes from the MDX Query: Measures: 1. Sales Amount, 2. Units Sold, 3. Average Selling price Attributes: Last 4 Quarters, Part Description -The rows should have the part Description -Columns - The measures and the Quarters The place where i am stuck is that the grouping needs to be by measure type, so the first 4 data columns should be Sales amount for the last four quarters, the next 4 should be the Units sold for the last four Quarters and the last 4 should be the the average price for the last four quarters. I don't know how to group the columns to get the desired affect. Do I need to redo my query to come up with a different data set?

Hi Sam, I take an example on advantureworks 2008 cube. I assume your cube query like this: select {[Measures].[Internet Sales Amount],[Measures].[Internet Order Quantity]} on 0, [Product].[Product Categories].[Category].members * [Date].[Fiscal].[Fiscal Year] on 1 from [Adventure Works] the returned result: Category, Fiscal_Year, Internet_Sales_Amount, Internet Order Quantity. Then, on the report body, i insert a Matrix. The Category as its Rows, the Fical_Year as its Columns, right click the Column Group->Add Group-Column Group->Adjacent Right, the first data cell is filled with =SUM(Fields!Internet_Sales_Amount.value), the =SUM(Fields!Internet_Order_Quantity.value) for the second data cell. I believe this should be what you expected. See http://technet.microsoft.com/en-us/library/ms157334(SQL.100).aspx to learn more details about matrix Adjacent Group. thanks, Jerry