I am very new to SSRS. I created a report. I am pulling data from SSAS cubes. I have all my dimensions and measures defined in the cubes. In my report I have one dimension attribute (say A) and 2 measures (say X and Y). I want to display total something like this: A X Y aa 1 2 bb 2 3 cc 3 4 ------------ 6 8 I right clicked ont he measures column and selectd add total. But this is what I got: A X Y aa 1 2 -------------- 1 2 bb 2 3 -------------- 2 3 cc 3 4 --------------- 3 4 i.e total for each row. But I want the grand total in the end of the column. Please help!!

Since no one replied, I found the solution. I right clicked on the sum , add group, parent group and selected the respective column to group by.